Formula: Set blank cell text if another cell contains certain text


I have a sheet with 2 columns: Shift and Provider. If the Provider column is BLANK AND the Shift column contains "Primary", I want the Provider column to say "Coverage Needed", otherwise it should display whatever name is in Provider column.

I've played around with several variations of formulas but always receive a circular reference. I'd like it to look like below.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!