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?

Find more posts tagged with

Accepted answers

All comments

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?

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.