I am trying to get this formular to do a different formular based on values in a specific column.

Options

=IFERROR(IF(CurrencyBuildLocation@row = "CAD", ([Revenue $ CAD]@row - [Total Costs]@row) / [Revenue $ CAD]@row), IF(CurrencyBuildLocation@row = "USD", ([Revenue $USD]@row - [Total Costs]@row) / [Revenue $USD]@row))

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!