-
How are institutions using Smartsheet to manage incident reporting workflows?
Hello, How are institutions using Smartsheet to manage incident reporting workflows that involve notifying multiple departments, each responsible for investigating and reporting back? I'm interested in examples or ideas on how to set up the sheets and workflow to streamline this process.
-
Change Status Based on Previous Row
I am trying to create a column formula that will change the status of a row to "Ready for Work" when status in the row above it changes to "Complete" I tried to follow the information that was provided this thread, but I keep getting #UNPARSEABLE: I already have an auto-number column (Job # - font is just in white based on…
-
Bridge: Failed to parse module params : Required parameter Sheet has not been defined
Hello, I am trying to figure out a resolution to my workflow. Parent Workflow: Trigger: when new row added, with filter to Search the sheet that is flagged (have formula to flag newest submission in source sheet). It is successful and the array contains the data that will be utilized in the child workflow….until… it…
-
Lag in Workflow - When is Smartsheet Checking Criteria?
I have a simple workflow with a trigger on When rows are added or changed. The field is status field that I would like Smartsheet to add a timestamp when the status changes: What I have noticed is there is a two minute lag in this simple automation, however, I am also noticing that it's not just a lag. What I see if…
-
Document Generator Quit Working
My document generator on 2 of my sheets just stopped inputting the data into the PDF forms. It will name the file correctly using one of the data fields but won't put the data in the file anymore. I remade my form and the automation like 10 times! The file is small, sticker size 2.25 x 1 and has a barcode font on it. This…
-
IF FORMULA FOR GOING-TO-EXPIRY EXPIRD-SOON EXPIRED AND VALID CERTIFICATE
My criteria are the following: If the Expiration Date Column cell is more then (60) days remaining = “Valid” If the Expiration Date Column cell is less then (60) days = “Going to Expiry” IF the Expiration Date Column cell is Less then (30) days = “Expired Soon” IF the Expiration Date Column cell is between (0) days to…
-
IF FORMULA FOR GOING-TO-EXPIRY EXPIRD-SOON EXPIRED AND VALID CERTIFICATE
My criteria are the following: If the Expiration Date Column cell is more then (60) days remaining = “Valid” If the Expiration Date Column cell is less then (60) days = “Going to Expiry” IF the Expiration Date Column cell is Less then (30) days = “Expired Soon” IF the Expiration Date Column cell is between (0) days to…
-
Approval Workflow: Record Name of Person Who Approved
When a approval request goes to multiple people, is there a way to record into a column the person who did the approval (e.g. Approved By column). I can see out who did the approval by reviewing the 'View Cell History' on the column that has the approval status; however, I would like to put the Approver name into a field…
-
Direct Email Approval Button for Smartsheet Automation Workflows
Integrate a direct approval button within the email notification itself that allows users to approve or reject requests without the need to transition to a web browser. This button would perform the same security checks and record the same audit trails as the current browser-based approval, ensuring that the process…
-
Adjust length of Workflow ID to prevent credit card misidentification by M365
We have recently implemented some automated workflows, and have found that Microsoft 365 identifies automated emails from Smartsheet as credit cards. If we try to forward those emails to external users, or if an external user replies to that email and starts a thread with us, Microsoft 365 flags the email every time…