ISBLANK

JCrawford

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?

Paul Newcome

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

JCrawford

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?