Automatic Check Box

Nicole Hodges · 10/25/18

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å · 10/25/18

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 · 10/25/18

Hm, it's saying "unparseable"

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

Andrée Starå · 10/25/18

Try this.

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

Nicole Hodges · 10/25/18

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

Andrée Starå · 10/25/18

Happy to!

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

Paul Newcome · 10/26/18

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

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

Comments