Workday function

Colin Chee
edited 06/06/24 in Formulas and Functions
I am trying to use the "Workday" function. It requires the Start date and "duration".I tried to get the duration from the "duration" column of my Gantt chart but because it has a suffix of 'd' for days or 'w' for weeks, the function ends up with an error. It cannot handle that format. So I had to create another column and put =Duration@row which returns the number of working days and then I can refer to that cell. While that works, its clunky. Is there a better way?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!