Report Filter based on the Sum of Two Columns without creating a new column
Options
Is there a way to create a Report filter that checks the sum of two columns for comparison. Example: I have two columns that contain percentage values. I want to include rows in my report where the sum of the two percentage columns = 100%. Trying to avoid adding a column to sum the values if possible.
Best Answer
-
There is not. You will need to create the extra column.
Answers
-
There is not. You will need to create the extra column.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!