Identifies if a row is on the critical path
Sample usage
=IF(ISCRITICAL([Task Name]@row),1,0)
  • ISCRITICAL(value)
  • ISCRITICAL(value)
    value - The row at which a user would calculate the isCritical function

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

This formula will return a boolean value based on whether the row is on the critical path. If dependencies are not enabled, you may see  #BOOLEAN EXPECTED, #INVALID COLUMN VALUE error.  You can reference any column as the Value, as long as the row reference is the correct row to evaluate.

Still need help?

Use the Formula Handbook template to find more support resources and view 100+ formulas, including a glossary of every function that you can practice working with in real time, and examples of commonly used and advanced formulas.

Find examples of how other Smartsheet customers use this function or ask about your specific use case in the Smartsheet online Community.

Ask the Community