-
How to set up an automation that is based on an if statement?
Hello! I am trying to set up an automation that changes a cell to "Complete - Pass" when four different conditions are meet. The way I am doing this is by adding and additional column that does a pretty complex if statement, and from that it either returns "Pass" or "Fail". =IF([QA Filter FAIL]@row = "Fail", "Fail",…
-
Copy Rows Automation
Hello, I am setting up 2 sheets. One Master Sheet and the other - User Sheet. I am setting a copy row workflow automation so that every day at 5pm rows added to Master sheet are copied to the user sheet. Before i implement and test this, i am wondering: Will Smartsheet know to copy only rows added that day(masters sheet)…
-
How? Column Formula to Pull Level 1 Parent Task Name
Hi Smartsheet Community, Please see image of setup! I am trying to create a column formula for the column 'TEST' that pulls the name of the Level 1 parent task for each row. Essentially, I want every cell in the 'TEST' column to display the name of its Level 1 parent, such as "baseline estimate" or "estimate R1," depending…
-
Sending automatic reminders for unanswered Update Requests
I am using Smartsheet with clients and they often ignore or don't notice Update Requests from Smartsheet. So they remain unanswered. Is there a way to automatically send reminders to people that did not respond to an Update Request? I'd love to be able to send a reminder every other day until the Update Request is…
-
Daily PO Status tracker, with visual alert, if delay in any of multiple department's queues
Need to combine multiple department's reports into I'm assuming a dashboard that visually shows the status of the parts on order for the PO with status of the queues after flipped to an order. I can't figure out how to push daily status of the parts on order for the PO to a central report, but maintains the history of the…
-
How do you create simultaneous / concurrent workflows in Smartsheet?
Our Quality Department oversees the new formulas and SKUs that must undergo an approval process before they are permitted to proceed to production. This process involves task completion by various departments, followed by necessary approvals from department managers. In total, six approvals are required. However, these…
-
activity log recognizing notifications
Hello, I have an automation set up to notify people when a row is added to a grid. I looked at the activity log associated with the grid and don't see an indication that it ran but am positive it did because I received it. Does the activity log not track certain types of notifications? Thanks
-
Automation Workflow Q: Daily Email w/ Multiple Criteria
Hello - I need some help setting up an automated workflow to trigger a daily email based on multiple criteria. Details on the use case are below: We have a sheet set up to assign daily tasks at an upcoming event. The majority of the tasks are assigned to individuals, which are indicated via the Staff Lead and Additional…
-
Lock the cells based on the duplicates
Hello Experts, I have 3 COMMENTS row duplicated and 1st COMMENTS row is having translation captured for the 3 language headers. However, there is 2nd and 3rd COMMENTS row. I have already enabled duplicate logic to highlight the row in YELLOW color, so the 2nd COMMENT row is highlighting in YELLOW. Is there any possibility,…
-
404 - Error Code 1006 "Not Found"
I am attempting to get an automation in place between Smartsheet and Excel. When running the script I am receiving a Response Status 404 with a response body error code 1006 message Not Found for every singe row. I have confirmed that nothing is deleted, permissions are fine and everything looks like it should. I just can…