Hi All! I hope someone can help me create a (functioning!) automation. I need Smarsheets to send a daily notification to task owners, if the task is marked past due. Currently, I have been able to cre…
This is a simple one but just having a hard time getting it to work. I have multiple clients who purchase a variety of products per invoice. I need a Sum of the Product Type per Client. I've attached …
Hi Smartsheet Community, I need to create a Smartsheet Automation to move rows into an archive sheet when record id appears in the Primary sheet, but does not appear in the Uploaded sheet. Another Aut…
Hi, When the automation send notification emails, most of the time the reply-to is the sheet owner but sometimes it is the person who modified the sheet. Looking at the documentation, I found this art…
Is it possible to copy a row to another sheet and have it copy multiple times on sheet #2? For example on sheet #1 I have a project with multiple dates for different deliverables within the overall pr…
We have created automation to generate a document based on a submitted request. Automation then sends an email with link to our case queue to be parsed out to the appropriate people. Everything I can …
When Using SUMIFS(Range, Criterion Range 1,Criterion...) I have multiple columns for example Estimate Spend, 25% spend, 50% spend, Rather than having multiple %'s of spend I just want to be able to us…
Hello, I want to use the Smartsheet API to update the content of a cell. I have set the API key in the header and tried the following using Postman: PUT Request URL: https://api.smartsheet.com/2.0/she…
Apologies if I'm repeating a question but I have not seen an answer. We have a Master sheet that users are inputting data through forms. Included is an auto generated unique identifier. We are also us…
I have several workflows to auto-populate a required reading column value based on what procedure is being performed. Most of them work just fine, but a couple of them are changing when they auto-popu…