Automatically Check a Box upon entering a date

In my Smartsheet sheet, I'd like to enter a date in a column and it would automatically check a box in another column. FYI - I have a surveyor in the field entering a date of his survey and I have a Manager who just needs to know the survey took place, but doesn't want the date.

Any advice is appreciated.

Thanks,

Find more posts tagged with

Construction

Sheets

Comments

Paul Newcome

Put this in the checkbox column...

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

Tom Noonan

Thanks Paul, it worked for that line, but when I tried to drag the formula to the entire column it doesn't work. Is there a way to tell it to work with the whole column, that way if I add a new row the formula stays in tack.

Thanks again

Paul Newcome

What do you mean by "it doesn't work"? What exactly is it doing when you drag it? The formula itself is written to work on every single row on a row by row basis.

Tom Noonan

My apologies Paul, I was doing it wrong. I selected the formula and then dragged down the blue box on the left to make it do the full column.

Thanks again!

Paul Newcome

Glad you got it figured out.

Happy to help!

Sign in to join the conversation!

Quick Links

Trending discussions

Linking sheets - Trying to build off of information from other sheets
Hello! I am pretty new to the intricacies of the platform as I'm looking to lead some project management and automations for the organization I'm in. I have a sheet I am trying to build Automations into, but would like to see if anyone can walk me through how to link this information from other sheets, as they get updated.…
Unable to Change or Delete Any Dates
I am unable to change any dates in my project schedule. It does not matter if it is a blank cell, automated cell, manually entered cell, new line I create, existing line, etc. — no matter what, if I attempt to modify a date, it just enters as 9/11/2025. This started last time I used my file. I have made sure cells aren't…
Restore multiple cell changes from Snapshot
Today a team member accidentally changed several rows by either deleting the data or the row itself. Do I download a snapshot of each one to restore? Some of them didn't seem to be too helpful. What is the protocol for restoring this information? I've only done this before with the help of a representative and it was…