Is there conditional formatting function available to trigger a notification in smartsheet when a date is booked for two of the same items? For example; in a scheduling sheet, when the same equipment is booked on the same date?
This discussion has been merged.
It would be super helpful to have the ability to create an automation/workflow from a report so that my team can get ONE comprehensive email/alert each week for a "request for updates" across all sheets that are being pulled into the report. It can be daunting for a user to receive a similar alert via an automation or…
Hi All, I have built a workflow where once certain conditions are met we send an alert to a few stakeholders where we give row details and reference some details stored in the sheet summary. At the moment I have not found a way to directly reference this information without adding a helper column to the row and using a…
I have a large Data Table that gets fueled daily with fresh information. There is a 'KEY' column that uniquely identifies each ROW of data. Using a Data Shuttle, I am fueling a regular sheet with only SOME of the data from the Data Table. Unfortunately I cannot find a way to filter the Table with ANY (and) ALL logic. What…
we are just able to trace an approval request on the column. there would be a list of approval requests like update requests. Also, would be better to manage those approval requests like cancellation, trigger from start again (we can use sequential approval requests in one automation) etc.
Hello Smartsheet Community!!! Is there a way to find a specific workflow by name or id? Currently I have to scroll thru ~80 workflows to find the one I am looking for. Ty!!!
We have many project plans that are in our portfolio and I want to be able to report from each project plan when a CHANGE is made for only three fields of the many that are on the sheet. The fields are in the sheet summary and then in a formula in the first row of the project plan for reporting purposes. My goal is that if…
Hello, Currently, I keep track of all workflows created and their ID's. It would be super helpful if we could search for workflow by the NAME or ID versus having to scroll and find it. Thank You - Smartsheet Ambassador😊
Hello, So I have two columns: "Date Week Ending" that lists the last Saturday of each week and "Reference" that lists an X value. I want to have the X value appear for the PREVIOUS week ending date when my current week starts. For example, if today is 9/9 then I want the "X" value to appear for the week ending date of 9/7.…