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.
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!
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.
Hi Community, Welcome to the Product Feedback and Ideas space where you can help shape the future of Smartsheet! We really appreciate your feedback and will take all posts into consideration. Our product team will review top ideas and requests monthly and we'll share updates as soon as we get them. Remember: if you have a…
It would be fantastic if there was a built in way to group reports by month or year based on a date column. Something in the group settings when you choose group. If you select a date column you would have these options Oldest to Newest by Year Oldest to Newest by Month Oldest to Newest by Day Newest to Oldest by Year…
Sometimes, mistakes happen and someone may adjust column properties, names or other sheet functionality that the owner may not want. Maybe the person who made the changes meant to make them on a COPY of the sheet and accidentally made them to a master sheet (we recently had a similar scenario happen). It would be GREAT if…
I would like to be able to lock a row (and thus prevent editing it's content) WITHOUT locking the ability to add, update, edit, or delete comments from that row. User story: We have a project schedule template with deliverables, milestones, tasks, and dates. The date rows are locked because they are cell-linked to project…
©2024. All Rights Reserved Smartsheet Inc.