Enter value if other cell is not blank

image.png

I would like the cell in the Cologuard - Agreed column to auto populate 1 if the cell in the Date cologuard ordered is not blank

Thanks in advance!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!