Circular Reference

Lexi P

I am working on a RAID log and want the "Next Action Owner" column to be filled in with the name in the "Created by" column if people do not add a name in the "Next Action Owner" column. Is there a way to edit the formula that I currently have in the "Next Action Owner" column to have this done without receiving a circular reference error? The current formula is =IF(ISBLANK([Next Action Owner]@row), [Created By]@row, [Next Action Owner]@row)

Cory Page

Your best bet in this case would be to create a column, there might be a way but its probably more complicated. Just create another column called "Next Action Owner (Formula)" or something then use your same formula to populate it. Adds a bit of extra data to your sheet but it will resolve your problem quickly and easily without having to update any forms.

=IF([Next Action Owner]@row = "", [Created By]@row, [Next Action Owner]@row)

Cory Page

Your best bet in this case would be to create a column, there might be a way but its probably more complicated. Just create another column called "Next Action Owner (Formula)" or something then use your same formula to populate it. Adds a bit of extra data to your sheet but it will resolve your problem quickly and easily without having to update any forms.

=IF([Next Action Owner]@row = "", [Created By]@row, [Next Action Owner]@row)

Lexi P

Thank you for your help!