-
Formula to change the color of a task name or date cell, based on another date cell
Hi all! Theoretically, I'd like to state: If the cabling will be delivered, but it won't arrive within 14 days before the date of installation, then change cell color of these tasks below to indicate the need to order temporary/alternate cabling solution. I realize it may be too dynamic to only be set-up in conditional…
-
Secondary action after generating PDF
In an intake sheet I'm having the information entered mapped to a PDF document. I want to see if there's a way to have an automation to checkmark a checkbox when that document is generated (as a secondary action) but I'm not seeing the additional "+" like in other automation workflow. Is there a way to have that trigger?…
-
Copy a Notification as an sheet attachment for a specific row
I am using SmartSheet for various Change Managment approvals, notifications tracking, and auditing automations. Is there a feature or way that when an Approve / Decline automation is triggered, the notification and response tied to the row where the trigger originated from can be saved as an attachment? We would use these…
-
Formula for highest education level
I am currently creating a visual for 150+ people's education levels, dropdown columns shows a majority of people has up to an masters degree but around 10 of them have doctorate/Ph.D. on top of it. What is a formula I can use to count the number of master degree holding individuals whilst EXCLUDING those with…
-
Automated sharing of provisioned projects
Adding a built-in function that allows to share provisioned projects based on a contact present in the intake list of the blueprint in question, without having to code cloud integrations.
-
Communication Log
Much like the sheet Activity Log, a log of communications sent out via the sheet would be very helpful. This would give sheet owners/users the ability to easily pull communications sent either via automated workflows or manually from the sheet, when individuals claim to have not received such communications. If an…
-
Automation on WHO made the status change
Hi, We have a sheet that has over 1000 rows. There is a column "Status" that has many options to choose from. Is it possible to have an automation that will go out once a day to me with all the status changes and WHO made the changes. I know we can go into the cell history but that will be a lot with all the changes…
-
Why am I being told "Workflow timing is unavailable" when I try to set it to daily?
Trying to make this automation run daily, but it's saying I can only set it to "When Triggered" but I can't figure out why. It's just a simple alert workflow. Any ideas?
-
Having trouble with a workflow
Hi! I am having trouble getting my automation to function properly and need some help troubleshooting. I have 2 sheets, A and B. I have one automation that sends a copy of a line from Sheet A to Sheet B based on a drop down selection. This works fine. I tried to set an automation on sheet B that impacts the same line…
-
Automating Start Dates and End Dates within a Project Plan
Hello there! How do I automate or create formulas to predict start and end dates for a project plan / timeline in Grid view? We have four stages - Planning and 3 to 4 different Creative Asset delivery dates for 4 departments. Look forward to your guidance here!
