If not blank then change contents of another cell


How would I do this formula?

In column "Status" on row 3, I need to change it to "Completed" when column "Assigned To" on row 4 is not blank.

I started with =IF([Assigned To]4) and was kind of stuck after that.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!