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.
Prevent that modified date is set when value formula has been changed
Hi smartsheet,
this would be very helpful: Make formulas configurable, if modified date is set, when resulting value is changed, or not.
Background (as an example):
We use a date formula called "relevance" with the result "today" for specific combinations of start dates, end dates and status.
This "relevance date" is extremely helpful in reports, where it can be used be as an easy "when" filter - and the "what" filter is free for other complexe combinations.
Kind regards,
Michael
Comments
-
The Modified date is a System field and will allways change when the record changes. You would need to structure something out of another date field and a check box that would either enter a datr into the field or not depending on the tickbox.
-
I would like this functionality as well! It would make it possible to generate a proper Burndown Chart for scrum
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 142 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives