-
Workflow History
Is there a way to access workflow history as an admin/creator of the sheet. It would make testing new workflows much easier if I could see when they had run.
-
Conditional Formatting To Red out a Row, if ID# has been used before
Hi all, I am trying to create a conditional formatting to mark a row Red if the ID# has been used before. I have plenty of conditional formatting experience however I just can't seem to figure this part out. Basically in a list of projects I.e 1,2,3,4,5 they move at different speeds and sometimes a project wont be on a…
-
Automation to send past due notifications to members
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 create an automation that will alert owners when a task becomes past due; however, this is a one-time notification. I've…
-
Simple Sum question
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 an image. For example, I'd like to know Sum of Product 1 for Client 1. In this case the running total =5. I realize I could…
-
Smartsheet Automations
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 Automation that I need to create is to copy rows into the Primary sheet when the record id appears in the uploaded sheet but…
-
How to set the reply-to on notification emails?
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 article: Overview of Automated Notifications Sent via Smartsheet | Smartsheet Learning Center The article says this: "In most…
-
Can I copy a row to another sheet more than once?
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 project. I need these projects to copy over to a 2nd sheet where we get a separate line for each date. Right now we are…
-
Does anyone know why a link to an attachment would expire in 14 days instead of 30?
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 find on attachment links indicates they expire in 30 days or when accessed 100 times. Our attachment links expired in 14…
-
I am trying to manipulate my SUMIFs Formula
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 use 1 reference and multiply it by 0.25 or 0.5 in the first "Range" category so =SUMIFS({Spend} * 0.25, {Phase}, "phase 1",…
-
SmartSheetAPI PUT
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/sheets/{sheetId}/rows/{rowId}/cells/{columnId} Request Body (JSON): { "value": "test", "displayValue": "test" } However, I'm…
