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.
Hello, I'm working through the writing formulas optional activity and in the 'Nested IF function - Progress Column' task it directs you to put in the following formula '=IF([% Complete]@row = 0, “Empty”)'. However, when I put this formula into the spreadsheet, '04a_Marketing Request Tracker - Formulas', I get an…
I have an automation that has a condition where I am looking at the column "LEA Interco Supporting Site(s)" and trying to find columns that have the value "Fort Loramie" in them. This works well when "Fort Loramie" is the first item listed in the cell, but it doesn't work when "Fort Loramie" is the second or third value in…
Have any of you created a Smartsheet that would show the savings for a project by the month? In other words, if I saved $1200 annually and the project ended in say March, then the savings would go $120 per month, Mar 2025-Feb 2026. I have done it on Excel sheets manually, but I think there should be a way to do it with…
