Enter value if other cell is not blank

jcurry

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!

Nick Korna

Hi @jcurry,

This should accomplish your request by formula:

=IF([Date Cologuard ordered]@row <>"",1,"")

Hope this helps; any problems/questions etc. then just post! 🙂

Nick Korna

Hi @jcurry,

This should accomplish your request by formula:

=IF([Date Cologuard ordered]@row <>"",1,"")

Hope this helps; any problems/questions etc. then just post! 🙂

jcurry

Thank you again @Nick Korna !!