ISBLANK


I need a formula for the following: If "Project Number" is blank then copy data from "Temp Project Number" (from the same row) and paste it into the "Project Number" field.

=IF(ISBLANK([Project Number]@row), [Temp Project Number]@row)

I get the #Circular Reference error message with this formula.

Does anybody have any suggestions?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!