Date Columns with Formulas
Date-related functions, e.g. Gantt or Timeline, don't accept columns that use formulas but have dates as the output. This limits the functionality and at times makes date-related formulas obsolete.
Comments
-
If you have DataMesh, you can use this to populate those columns. It's not a fix, but it is a workaround as there are times when we need to do this… it's on my list to do a YouTube demo on when I get to it. But yes, would be good to be able to do this natively without needing to have to create a DataMesh. Same applies for the primary contact column used in Resource Management.
Rich Coles
Prodactive | Smartsheet-aligned Platinum partners
Check out our Smartsheet-dedicated YouTube channel for tips, tricks and inspiration
- Hi Community, Welcome to the Product Feedback and Ideas space where you can help shape the future of Smartsheet! We really appreciate your feedback and will take all posts into consideration. Our prod…
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.7K Get Help
- 438 Global Discussions
- 152 Industry Talk
- 497 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 509 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 36 Webinars
- 7.3K Forum Archives
Trending Ideas
- With around 80 automations on some of our sheets, it would be great to have just a really simple folder view of automations. At the moment having to scroll endlessly (even though they are organised as…
- There should be a way to restrict dropdown options on forms that are external facing that also have internal uses without setting up additional reference or separate internal/external columns. Use cas…
- Is there or could there be a dark mode? My eyes are killing me with the super bright white screen.