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,
Comments
-
-
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
-
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.
-
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!
-
Glad you got it figured out.
Happy to help!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives