Automatic Check Box

Nicole Hodges

Hello,

I would like a checkbox column to automatically be checked when a date is put in a different column.

For example, when "Call 1 Date" is populated with a date, check "Call 1". 

Would I create a formula in the "Call 1" column?

Andrée Starå

Hi,

Try this.

=IF(ISDATE(Date@row); 1; 0)

I hope this helps you!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Nicole Hodges

Hm, it's saying "unparseable" 

Perhaps I need to include the column names somewhere in the formula?

Andrée Starå

Try this.

IF(ISDATE(Date@row), 1, 0)

Nicole Hodges

Ah, man this did not work thank you for helping, Andree!

Andrée Starå

Happy to!

Does it still not work? What error message do you get? Which column are using for the formula?

Paul Newcome

=IF(ISDATE([Call 1 Date]@row), 1, 0)

 

Give this a shot. The bold and underlined portion would be your column name.