Enter value if other cell is not blank


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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!