Can I re-set baseline if baseline columns are used in formulas or conditional formatting rules
I have a conditional formatting to color code status cell based on risk level of the task (on schedule, behind or begin scheduled but not started). That works if I use start and date columns as planned and never change while tracking of progress - change only status and progress columns.
If I want to trace actual start and end dates, I need to use baselines. And my conditional formatting should be based on base line start and finish dates, not on actual dates. So I enabled baselines and change my conditional formatting using base line columns.
Adding rules against base line columns prevents changing such columns and removing such columns.
Am I correct to assume that re-setting baselines implies removing base lines from the sheet and re-adding them anew? In this case, how can I re-set baseline for plans where I use baseline columns in rules?
Best Answer
-
Hi @Vadim K
If you are just resetting the Baseline, then this simply updates your current Baseline columns with the new dates.
This means that your Conditional Formatting rules will stay associated with the exact same columns even though you hit "Reset"! No need to change anything.
However if you click Remove (versus Reset) and then re-add Baselines into your sheet, this would create entirely new columns so you would need to adjust all of your Conditional Formatting rules to look at the new columns before deleting out the old, original Baseline columns.
Let me know if I can clarify anything further.
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Answers
-
Hi @Vadim K
If you are just resetting the Baseline, then this simply updates your current Baseline columns with the new dates.
This means that your Conditional Formatting rules will stay associated with the exact same columns even though you hit "Reset"! No need to change anything.
However if you click Remove (versus Reset) and then re-add Baselines into your sheet, this would create entirely new columns so you would need to adjust all of your Conditional Formatting rules to look at the new columns before deleting out the old, original Baseline columns.
Let me know if I can clarify anything further.
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 213 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives