Formula to Check a check box

BESP10

Good afternoon all,

Quick question,

How do I create a formula that will check a check box in a column if the value in abother column is not blank?

So, per below I would like to create a column formula that will check the box in the "Comment Check" column if the "Comments on Work Completed" column is not blank

Thank you all

hollyconradsmith

Hi @BESP10 ,

Try =IF(NOT(ISBLANK([Comments on Work Completed]@row)), 1, 0)

hollyconradsmith

Hi @BESP10 ,

Try =IF(NOT(ISBLANK([Comments on Work Completed]@row)), 1, 0)

BESP10

perfect thank you @hollyconradsmith