Is there anyway to use a formula to calculate a value from several column summaries? For example, if I have 3 column summaries (Column A, Column B, Column C), I’d like a formula that could provide a value for formula = (Column A Summary-Column B Summary)/Column C Summary. Is this currently possible in base monday.com product, or with an add-on app?
In addition, I’d like the values in the column summaries to change based on the information being filtered and have the formula adjust automatically.
If Monday does not provide this functionality in its base product, you might be able to achieve your desired outcome using Make that extend the platform’s capabilities.
Using Make you can create scenarios (workflows) that involve Monday.com and other applications to perform complex calculations, manipulate data, and automate tasks based on triggers or specific conditions.
Mondaycom currently doesn’t directly support formulas using column summaries. Workarounds include creating helper columns with automations or using third-party apps, but these have limitations. Consider using external tools like Google Sheets for complex calculations and importing the results back into Mondaycom.
YEs, (if Im understanding correctly), you would need to do a ‘add’ formula in a separate column and that separate formula column would then have a summarizing at the bottom in which you can showcase into a ‘number’ widget in a dash board.
