Sign in to join the conversation:
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?
Hi,
Try this.
=IF(ISDATE(Date@row); 1; 0)
I hope this helps you!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
Hm, it's saying "unparseable"
Perhaps I need to include the column names somewhere in the formula?
IF(ISDATE(Date@row), 1, 0)
Ah, man this did not work thank you for helping, Andree!
Happy to!
Does it still not work? What error message do you get? Which column are using for the formula?
=IF(ISDATE([Call 1 Date]@row), 1, 0)
Give this a shot. The bold and underlined portion would be your column name.
I have inly one user in my trial account. When I am trying to upgrade to PRO plan it is defaulting for 2 users and not allowing me to upgrade the plan for only one user. Please help.
We are curious if anyone is experiencing issues with automations that are to generate emails. We've been seeing gaps with a number of these automation on various sheets, where the sheet will record a date of when the email was sent, but it is either never received by the recipients or it is received hours or a day later.…
I can create a Chart in Dashboard from sheet well but from Report is not working now. I just try with simple Report (just contain 2 column Primary and Number) but cannot make the chart. Is there any changes recently right, because I haven't worked with Smartsheet dashboard for a long time and I remembered that I could do…
