Use Resources AND calculate dates?
I'm looking for a workaround for this. I understand that with recourses turned on I can't put formulas in the Start and End Date. I have other columns that I'm using with formulas to calculate dates that I need. Is there any way to use Resources and have it reflect calculated dates on a sheet?
Thanks!
Answers
-
Hi Jeana,
Currently it's an either-or situation...
Either you can have your own custom Start and End date columns that you can use formulas in separate from Resource Management,
-or-
You enable Resource Management which uses its own special type of Start and End date columns that cannot have formulas.
The way I think of it is that the Resource Management capability is a type of formula in the background, so this takes up the ability to input a second formula. You can read more about formula restrictions in our Help Center, here.
Please also submit an Enhancement Request when you have a moment!
Thanks,
Genevieve
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 443 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 290 Events
- 35 Webinars
- 7.3K Forum Archives