Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
Is there any way to delete a column with conditional formatting in smartsheet using smartsheet C# SDK?
When attempting to delete a column that is involved in a conditional formatting rule you will receive an error back stating it is used in a conditional formatting rule and the rule needs to be deleted first before the column can be deleted.
At this time, the Smartsheet API doesn't have the ability to interact with conditional formatting rules to perform the deletion or any other actions on conditional formatting rules. The conditional formatting would have to be deleted manually by someone working with Smartsheet in their browser. Then API requests could be made to delete the column.
Hi We have a few automated python scripts that run on a VM at different cadences, typically every 8-12 hours. One of the functions of these scripts is to delete all the rows in specific sheets. This is done by iterating over the sheet in chunks of 70 rows at a time, and then calling …Sheets.delete_rows(…), etc. Lately, we…
The problem We manage a workspace with ~340 engineering projects, each in its own folder with a Master Data sheet. We use automated scripts (Python + SmartSheet API) to maintain phase-based reports that group these sheets dynamically — e.g. all projects in "Execution" phase in one report, all in "Backlog" in another.…
This morning around 7:50AM central, we started having some routine API calls to get a sheet get stuck. A response from Smartsheet never seems to be returned, but I do get this error from the call (I'm using Powershell) Invoke-RestMethod : upstream connect error or disconnect/reset before headers. reset reason: connection…
