Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Formula to block dates
I want to be able to not allow a training date to be entered, that is less than 5 days after the current day.
If they try to enter let's say today's date, 7/31/15, it would not allow them. However if they enter a date that is 5 days or greater from today's date of 7/31/15 it would allow them to do so.
In Excel I am able to create data validation and stop them from entering a date less than 5 days out. Can I do the same in Smartsheet?
Tags:
Comments
-
Smartsheet does not have data validation but you could build a conditional formatting rule that formats the text/cell if the date selected is less that 5 days after the current day. It wouldnt prevent the user from entering the date but it could deter them.
This discussion has been closed.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives