Smarstheet formula

How can I use this highlighted formula. Appreciate quick response

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    To get the duration you can either use

    =[End Date]@row - [Start Date]@row

    to get the total number of days,


    or you can use

    =NETWORKDAYS([Start Date]@row, [End Date]@row)

    to get the number of working days.

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

Answers