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 ✭✭✭✭✭✭

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

Why are my Task Rows expanded every morning?
I've been using smartsheet for a few years now and never had this issue before, but starting this year, every morning when I go into one of my project sheets at the start of my work day they are ALL expanded. I have parent and child tasks that are 100% completed a year ago that are now suddenly expanded every morning. So…
Where are the AI (formula generation) icons now? 2025
Before, I was used to seeing the AI icon listed on the right side menu, at the bottom. where is the AI formula generator icon now in 2025?
Disable Comments for a single Sheet?
Is it possible to disable the use of comments on a single sheet? Or is there a way to get an alert to someone, perhaps sheet owner/admins or a special group when there is a comment added?

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