Automatically Check a Box upon entering a date

Tom Noonan

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,

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!