I am trying to figure out how to have a "status" change to past due if the due date occurs and the status is not "complete." Is there a way to do this? Thank you!
Hi, I have below automations set for a sheet that gets the values from another sheet by index(match) function, and that another sheet is being updated on a daily basis. As can be seen in this example,…
Hi, I want to automate the status column of the parent row based on the child rows. For example, if all of the child rows are left blank or marked "Not Started," I want the parent row to read, "Not St…
I am trying to create an automation that changes a cell when another cell changes. For example: When status column field changes to On Hold, the Health column field is to change to the yellow circle (…
I am still pretty new to Smartsheet and although I have set up a few simple Automation for some Smartsheets, I'm having trouble setting up my current one (I am not getting the notification Emails). Th…
Data in Arabic charecters/letters in my sheet are not verified/seen when generate filable pdf doc and instead it shows blank space. This issue only when generate local PDF doc , Google Doc are fine to…
In my Smartsheet I have an Install date column. I'm using this to schedule software installations and the dates may change. I set up the following automation and I tested it using fake store informati…
Hello- I'm trying to use the "record a date" workflow to record when a new selection is chosen from a drop-down list, and the function isn't working for me. When I choose the trigger column in the wor…
Are there global automation permissions, where the Limited option can be set across the board? All I could find was Permissions in Security & Controls. For any new sheet created, I want to default the…
Hello, I'm looking to create a capacity vs demand utilisation RAG Column where it will appear with Red, Amber, Green for the following rules: Green: Total Q1 Capacity = Q1 Total Demand Yellow: Total Q…
