More functionality for for rules
The rules feature is nice but it is very limited and only allows to change things from different fonts, colors, strikeouts, etc. I would like a rule that allowed more detailed changes. For example, if column a says completed, changed column L to 100%. There are many different scenarios.
We are unable to use the predecessors feature because we must allow the flexibility to have some items be done much sooner than we would prefer or much faster and/or allow different tasks and dates to move around in the project. This means the gantt chart does not work well for us so we manually create our own formulas. If we could put in a formula that says row L is labeled homework, make the duration 7 days somehow without using the gantt and having to manually create the entire sheet with these formulas that would be a nice feature. We change our project templates frequently so this is quite a bit of manual work.
Comments
-
Hi Julie,
It sounds like you're looking for a type of "function builder" that makes functions easier to create, possibly something that allows you to create one function for an entire column more quickly. Please submit a Product Enhancement Request for this using the form under Quick links on the right of the community site to let our Product team know that you'd like to see this in a future version of Smartsheet.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!