-
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…
-
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…
-
Flowcharts & Diagrams
Hello, I would like to see a Flowchart and Diagram implementation added to SmartSheet. I would like to have all my data in one location, versus having to utilize multiple applications for my data.
-
Reminder/Alert Automation
I have this tracking ticket Smartsheet where every 2 weeks, my team of 4 analyst rotate on who's in charge of addressing these tickets. These tickets don't have deadlines, they just have quality information (e.g. ticket name, description, submitter, status, location of issue). I want to create an automated reminder for…
