SUMIF Different Columns

Hi, I have two columns [Initial Priced Amount] and [Final Account Amount], what I am trying to do is use the amount in [Initial Priced Amount] if the [Final Account Amount] is blank, but if it isn't blank then use the amount in it, the [Final Account Amount] column.

I want to use it in a couple of formulas in other columns in the same way, see formulas below;

=[Final Account Amount]@row - [Costs to Date]@row

=IFERROR([Difference - Cost vs Final Acc]@row / [Final Account Amount]@row, " ")

So basically what I'm trying to achieve is that if the [Final Account Amount] is blank use the [Initial Priced Amount] in the above formulas, but if it isn't blank use the [Final Account Amount].

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!