Identify 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 Smartsheet Formula Template to view examples and practice working with functions in real-time.

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