I would like to see the critical path not in the Gantt Chart, but in the cells marked or ticked

Maida

Maida ✭

07/15/22 in Smartsheet Basics

I know that I can see the critical path in Gantt Chart, but I would like to see it in separate column as ticks or highlighted cells/

0 ·

Answers

Paul Newcome Community Champion

07/15/22

You can leverage the ISCRITICAL function for this.

=IF(ISCRITICAL([Task Name]@row),1,0)

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

how do you freeze a full work sheet
Prefill a form response from another sheet
I have a project tracker sheet and am trying to set up a flow to send a survey via a form once the status of the project is changed to complete. I would like the survey to prefill with the project name from the source sheet, of the project that was changed to closed. Is this possible? The form results (survey results)…
Dashboard View Restrictions
I created a resourcing dashboard that I would like to share with a team, however I would only like users to see their own details (not everyone in the team). Is this possible with current functionality? Any tips out there?

Help shape the future of Smartsheet.
Share your ideas and feature requests.