How do I programmatically update Start Date, End Date, Duration and Allocation %?

agautham

Hello everyone,

I am working with the python smartsheet SDK, and I am experimenting with a smartsheet connected to Resource Management, which comes with a number of default columns - few of them are Start Date, End Date, Duration and Allocation %. I see in the Python API documentation that these 4 columns are not allowed to be updated programmatically because they might be dependent on their child rows/sheets. But I see that Smartsheet allows to update these 4 columns on UI. So I am guessing is there some way to update it through API?

The sheet I am working with is a simple single sheet with no dependencies. Is there anyway to work around this restriction? Need some help here.

Thanks,

Adwaith

Isaac A.

Hi @agautham!

From reviewing our API documentation, you technically can edit those columns using the API if dependencies are not enabled. When dependencies aren’t enabled, the Start Date, End Date, Duration, and Allocation % columns are treated as standard Date and Text/Number columns, so there shouldn’t be an issue updating them programmatically.

However, when a sheet is connected to Resource Management, dependencies are enabled by default. Disabling dependencies would allow you to edit those columns via the API, but it would also disconnect the sheet from Resource Management.

You can find more information on project sheets connected to Resource Management here: Connect a project sheet to a Resource Management project.

I hope this helps!

Cheers,
Isaac.