-
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…
-
How to populate unique identifier created through form submission on one sheet to other sheets?
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 using the workflow automation to copy the entire row to separate sheets based on conditions. How can we populate specific…
-
Manage Workflow Area Improvements
Would be advantageous to have more control in the Manage Workflow area: -A way to batch automations by type -A way to custom organize automations -Different views for automations, such as a tile capability to be able to view more automations onscreen at once -Export automations to easily be able to see things like the…
-
Workflow to change a cell value isn't working properly (changing the values I input)
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-populate in the sheet. For example, I have the required reading for a specific task as "3941, 3987" but when the cell…
-
Smartsheet Calendar App vs Calendar View
My team sends out various reports on a daily basis. However, we have to reach out to different teams at different frequencies to ensure that we are sending the most up-to-date reports, as we don't have access to retrieve them manually. Typically, we send reminders using the "reminder" function on our "Report" sheet to…
-
How to automatically add child rows
I would like to add 4 child rows after each approved row. I understand the indenting would be manual. Workflow: User submits the project form and form information resides on sheet A Approver gets the notification and approves the project The project row gets automatically copied to Sheet B Add 4 child rows to the newly…
-
Fast status updates based on parent cell
I would like to make our status updates faster by utilizing the parent/child cell(s). If the user changes the status in the parent cell (dark grey line) to "Completed" then the child and grandchild cells would change to completed. If the user marks the child cell as one of the following statuses then the grandchild rows…
