Formula to populate blank cell, but ignore if not blank

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
    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?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!