is there some possible way how to set End date for Gantt with Hard Deadline. Basicaly we have function which is teling us when stock is 0. We need to set this date as end date for our gantt.
From the Smartsheet API documentation -- "the API does not support updating data in the End Date column under any circumstance":
Re how to get row Id and column Id, see the answer to this other Stackoverflow post: How to find a row ID or column ID in smartsheet?.