nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

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?

Find more posts tagged with

Comments

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.

Sign in to join the conversation!

Quick Links

Trending discussions

Internal commentary using contractor smartsheet
Hi All, I am new to smartsheets and am not aware of it full capability. However, there is something I would like to do. Now, I just need to know if it is possible. We have a technical contractor performing work on our company and they have a smartsheet they have share with us. I would like to make commentary and post…
Smartsheet and Excel
Can excel sheet be used as a reference in Smartsheet?
Why does Smartsheet show the following "You have 4 days left on your business trial plan"
I have a State account