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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!