Formula to populate blank cell, but ignore if not blank

SChristJLL

Hello SS community!

Need some help on a formula, I keep getting a circular reference errror.

Our Project Tracker Smartsheet tracks who submitted the original request and also who it assigned to.

The problem we have is some folks forget to assign themselves to a project.

I need an IF formula that will populate a blank Assigned To cell with the Submitted by name but do nothing if it's populated.

Is this possible to do within the same cell or do I need a helper column?

In my screenshot, I need D2 to read Seth's name since it's blank, but also do nothing in scenarios where this is populated.

Thanks in advance everyone!

Kelly Moore

Hey @SChristJLL

One approach is to add a helper column- a contact column, for the final assignment. You could name it something like Assigned_To. This would be where the IF statement would reside.

=IF([Assigned to]@row<>"", [Assigned to]@row, [Submitted By]@row)

Would this work for you?

Kelly