I have a very simple automation - email trigger when status changed. I has worked for over a year but suddenly stopped. I have duplicated, edited and updated the workflow and no change. I did see ment…
I am creating a process for multiple groups, but I need to retain ownership of the sheets. That said, the automated workflow emails need to appear to come from someone else in my organization. Is ther…
I have a sheet that is populated via a form. Many of the fields are automated based on what the user selects. For example, the user selects a Workstream, and individuals are selected from multiple dro…
Hello all! Does anybody know if SS has a way to restrict duplicates in a dropdown single select column? For example, "Project 4" is already using "D," so when I select a value for "Project 5," "D" wou…
I am trying to create an automated update request with placeholders {{ }} to make the messages more useful as the sheet has many projects on it and the receiver would not immediately know what the mes…
Hello, I'm trying to have an automated email notification send only once, once a criteria has been met. Currently, I have the automation emailing a notification to a contact once a certain field = 1. …
I am looking to create a sheet that moves through our 5 stages of work and how much time is spent in each phase. What is the best way to go about this?
I am stumped. I have tried various formulas only for them to error. The closest I have come is the following but I am missing pieces. =IF([End Date]@row = "", 0, IF(AND([% Complete]@row < 1, [End Date…
Hello Everyone, I have a basic project sheet with Start Date, End Date, % Complete Columns. I would like a formula for Symbols to do the following: Gray = If todays date is less than Start Date Red = …
I have a Master sheet where all of the data is stored. I also have other secondary sheets that have just the applicable columns for those groups of people. When I update a date or cell in the master s…