-
Limit on workflows triggering other workflows (aka daisy chained autoamtions)
I have a "Re-Release" process that is very long and complex. At one point in the process, a row goes through a series of automations that trigger each other. These automations copy the row to an archive sheet, move the same row to a "Re-Release" sheet, copy the ID# to an "Previous ID #" column, clear the data in over 60…
-
Automation Workflow - Approval workflow with condition
Hi, I am getting and error (image below) when i am trying to write a condition based approval workflow, please help
-
Merged: Group Management
This discussion has been merged.
-
Automation of responses from one form onto a second form?
I'm developing a skills competency checklist using 2 forms to collect info (1) self-assessment for staff to check-off skills and (2) Validation/Assessment from preceptor to check and sign-off that skills were validated. Is there a way to set up logic that auto populates responses from the first form onto the second form so…
-
Automation Work Flow
Hello Smartsheet Community, I've implemented an automation where changing the End Date field automatically sets the Status to "Completed" and updates % Complete to "100%." Here's the issue: When I update the End Date for line 42, it correctly updates the status to Completed and % Complete to 100%. However, line 41, which…
-
Help with Auto Number column formula
Hello, I've pretty new with Smartsheets and most of the time I try to use the examples from other posts that I have seen others put up in order to solve most of the problems that I have. Unfortunately, I cant seem to get this problem to work. I have 3 sheets, Source, Helper, and Destination sheets for an Onboarding project…
-
Automation Condition Not working
Hey all, I set up an automation to request an update if one field is blank and if another field is not a specific list of departments and I got an email this from someone in that department saying they got an email anyways. Can you take a look at the below screenshots and tell me if I'm missing something? Here is the…
-
Retrieving Ancestor (date) value from multi-level parent-child rows
Hi All, I used the following formula to retrieve ancestor (first parent) date value of the multi-level parent-child rows for each row. =LEFT(INDEX(JOIN(ANCESTORS(Date@row), ","), 1), 8) The issue that I'm facing is the return value being "TEXT" despite having "DATE" column type. Since I have to use this return value in…
-
How can I log a timestamp of a cell change?
I want to add an automation rule to write a timestamp of when a cell value changes, I know I can use the "record a date" automation to get the date but is there any way I can get the exact timestamp similar to the "created at" field in form responses? I am also looking into a way to implement it using the API and there…
-
Automated Email Reply After x Amount Of Days
I am looking for a way to set up a workflow so that once a box is checked, an automated email will get sent out to a person a few days later.
