Calculate/Compute the duration between two dates in working days

RedSPINE

Hello,

I'm back for more need in API tricks. Here's my case : because we can't edit the finish date of a task from the API, I need to find a way to make a task end at the date I want. For this, I either have the beginning date of my task, so I just need to find the duration to put in the corresponding field to have my task ending at the finish date I want.

As I work with python, I used the datetime module to get the time difference between the two dates and that's the result of this operation I used to put in the duration field. But of course, you should already think it does not work since the duration in smartsheet is a duration in working days.

From what I see, I do think it would be painful to check for every week-end or holiday that is inside the duration to remove the good amount of days from the duration.

I hope there's a smart way to do it with Smartsheet.

Thank you so much for your time,

RedSPINE

dAVE Inden

Getting the data of the sheet or the row you should be able to see the current value in the column being used for the duration of the task. You could then increment or decrement this value and provide it in a request to update the duration column. This will update the finish date in your sheet automatically based on your working days that are set in the dependencies of the sheet.

For example, assuming you have working days of Monday through Friday, if your task is currently two days long you would see the value "2d" in your duration column. If you needed to add one more day to it you could provide a value of "3d" in a request to update that cell. If this task currently ended on a Friday Smartsheet would automatically move it to end on the following Monday.