-
Using formulas to copy, or transfer data between cells.
Hello community! I am looking for a seemingly easy solution which I can't find. While the workflow automation helps in many ways, the "actions" available seem to be greatly lacking. For example in google sheets + scripts + triggers, I can have a cell update based on a formula from a time driven event (whether external or…
-
Smartsheet Lab - DocuSign
Is there a way to put parameters around what attachment does or does not integrate back into Smartsheet?
-
Individual formula editing changes the whole column
Not sure if this is supposed to happen, but since i was not expecting it at all, i found it extremely frustrating. So i have a spreadsheet that is using several index/match formulas on different columns to pull information from other spreadsheets. But today, one of the Admins on another spreadsheet made me aware that he…
-
getting cell value by row id and column id
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 using parameters MyRow.id,primary_col_id? Thanks
-
Make Collapse ALL default
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.
-
Alert a user when an automation isn't going to work
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 you have a fix for this, I would love it!). As the owner, I am notified when a user will not be alerted due to an incorrect…
-
How can I take a concatenated string and feed it into a form as an option?
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 fields. (It basically builds a unique name for each of our customer audits) and looks like this.. 2019_Jun_Fab5_Skyworks…
-
Can I Auto Assign Tasks to Myself?
When creating a new task can I have it automatically assign it to myself?
-
Script Editor, Deploy as Web App, like Google Sheets?
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/functions * Deploy as Web App: https://developers.google.com/apps-script/guides/web I'm looking to do something similar to the…
-
Regarding DocuSign integration: Is there any way to combine Workflow + attachments?
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 create an envelope from an attachment in Smartsheet, but then I have to rebuild the fields every time and I can't have them…