When a row is on the critical path, I'd like to be able to set conditional formatting so that it turns text red, or colours the cells, so that it is a more obvious visual cue that this task is a particularly important one.
Sign in to see the current vote count, add your own vote, or leave a comment.
Hey @Julian Sindall
You can use the function ISCRITICAL to identify if a row is on the Critical Path or not. For example:
=IF(ISCRITICAL([Task Name]@row), "Yes", "No")
Then once you have this in the grid of your sheet, you can set a Conditional Formatting rule based on that formula column!
Cheers,
Genevieve
Thank you - that's a useful workaround. I'll use that. Obviously it would be more data efficient to be able to conditional format directly, but this will do in the meantime :-)
I like the conditional formatting based on critical path, but I would love to see the rows of the grid that correspond to the gantt bars highlight when you select to show critical path or show summary path.
I have a workflow with nearly 40 automations, half of which are email-based requests for updates with various sets of triggers. While I know the automations work, due to months of testing, when our system went live to the institution, I became very worried that the automations wouldn't run and I'd have no idea whether or…
Description: When users upload multiple photos in one action via the Smartsheet iOS mobile app, all files are assigned the same generic name and timestamp. This makes it difficult to identify individual photos and creates confusion in workflows that rely on accurate, unique file naming. Why This Matters: Industry Standard:…
I am proposing bringing a bit of pizzazz to Smartsheet by having celebratory animations for certain criteria. Think Joyful Animations in Outlook! My team was hoping to have some sort of confetti pop/gif/image when we close out a project or hit a milestone. Bonus points if it is configurable like the automations are.
