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
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives