IF Statement reading dollars from certain columns

Options

We have a new column we are trying to figure out the formula for.

Our goal is to show TV Fee CPM column value in a new column if the Custom one is blank, but if there is a TV Fee CPM - Custom cost listed to show that one instead.

I am currently using this formula but keep getting an error:

=IF(ISBLANK[TV Fee CPM - Custom]@row, [TV Fee CPM]@row, [TV Fee CPM - Custom]@row)


Thanks for your help!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!