Lookup text and calculate values in cells from columns in the same row
The formula I'm using for this is working, but it feels like it could be completed in an easier way.
I want to look up the text "Grand (Total)" from the Rows column then divide the numbers from the Audits and Findings columns in the same row.
Any suggestions on how I could shorten this formula?
Tags:
Best Answer

That is about as simplified as it gets unless you wanted to start working with helper columns.
Answers

That is about as simplified as it gets unless you wanted to start working with helper columns.

Thanks for taking a look @Paul Newcome

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!