Lookup text and calculate values in cells from columns in the same row

John Renney
John Renney ✭✭✭
edited 12/03/21 in Formulas and Functions

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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!