Hi, we principally use smartsheets to generate Gantt charts for our various projects. Ideally we would like to set up conditional formatting (for example task-bar color) for all of the children of different parents.
So for example, let's say "Phase 1" of a project is the parent, we would like an
There are numerous posts on improving formatting on Reports.
Here is a specific use case:
I have a sheet with multiple date columns and tasks. On one report, I am showing (either Gantt or Calendar) view of the tasks color coded by task. In a second report, I would like to show the dates (either
Hi, all. I was looking to write a formula that would change a RYG based on if the project was still on track for the determined amount of time. It would start green and if the project was projecting as running longer than anticipated would change to yellow and then red when it went over a further
I'm trying to restrict a Done checkbox from getting checked before other boxes are checked first. My team created a project plan with multiple steps in the process. Each step has a done checkbox. I have a formula that fires when a specific box is checked but don't want folks to check that