Hi, I am the primary column id. I want to iterate over rows and get cellvalues of the primary col in python. for MyRow in my_sheet.rows: After this is there any direct function to get the cell value u…
I have clients with indented children. Everytime I come to the sheet the children are fully expanded. How do I make Collapse ALL the default setting? Matters not if I save it as collapsed.
I have a sheet where there is potential for an incorrect email to be added via a form (SS requires an email be entered for it to populate correctly into a contact column if not in the SS directory-if …
Can't figure this out.. I have form with 4 fields in it. The user picks drop downs off of each of the 4 questions and saves the form. In the sheet, I have a 5th column that concatenates all of the 4 f…
Does Smarsheet have the following capabilities? * Script Editor mode to create Custom Functions, like the Script Editor in Google Sheets: https://developers.google.com/apps-script/guides/sheets/functi…
I'd like to use the workflow to have a variety of fields and the signees autofilled, but there doesn't seem to be a way to include an attachment from smartsheet in the workflow. Alternatively, I can c…
Hello, We need to get a specific cell value given the row and column id via an api call. I get one way getting the history of the cell but this call has a problem when you call more than 10 times in a…
I am trying to build a UI using Google scripts to display the changes made to any given row. In other words, I want to capture a list of modified date, modified by and what was changed in a row if any…
What is the best way to automatically insert a set of (about 10) rows as child tasks under each project row? I am designing a smartsheet based on the Project Sheet template, but in my case we manage a…