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

What column are you putting the formula into? You need to put it in a column that is not being referenced by the formula.

Thank you! After I took a break and came back to it, I finally realized that was my problem. I will have to think of another way to accomplish this. Any ideas?
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!