-
Systems and Services subscription renewal dates
I have a sheet which tracks the various systems we use and their monthly & annual subscription charges. We'd like to have SS tell us when a renewal date is approaching, particularly with the annual charges at first, but then have that date push out to one year (or month if it's monthly). A notification email would then get…
-
Invalid Workflow - need help in resolving issue
I have an intake sheet where entries are added needing approval. I have a column set by a formula that looks up the type of request to determine the number of approvals needed. I was trying to send out the approvals right away but the formula wasn't resolving fast enough so I now have another workflow that sest a column…
-
Daily automations
I set up 10 daily automations for my SS to change a cell every hour from 8am to 5pm. I set the automations to be daily with no end. It worked yesterday until 3pm and then stopped. Nothing happened this morning. How can I fix this?
-
PTO/Absence tracker - how to deal with recurring events
I am creating a PTO/Absence tracker for our service technicians team. I have 2 separate input forms. - one to record/request PTO filled out by the service technicians themselves - another for Supervisors to book a service technician to a client site for a dedicated amount of time, - i.e., every MON for the next 3 weeks -…
-
Automation - Move a row to a Sheet using where the Sheet Name is a row Column formula.
In the setup of an Automation to move a sheet row to a sheet name that actually a row cell value. Want the automation to allow the 'Move to:' value to come from a cell located on the row being moved. This would allow this sheet-to-sheet automation to happen without a manual entry and enhance the automation abilities ten…
-
Merged: Automation: Delete Attachments
This discussion has been merged.
-
Merged: Archiving- Quick Way to Turn off all Automation Workflows
This discussion has been merged.
-
Bridge Workflows - Not able to add elements or states to workflow after adding Conditional Junction
Hi Community, I am building a workflow to automatically add 6 child rows to a parent row (which is entered by the user via forms). I am adding a conditional junction to check if the row is added by the bridge workflow or not. However, when I add that condition I am not able to add elements to the success state or fail…
-
MS Power Automate Get Last Row of Data
The desired flow is: Smartsheet form is completed which includes three key pieces of info: Name, Email, Waiver This creates a new row in a Smartsheet A Power Automate flow is triggered where it checks specifically the Waiver (which is a dropdown either needed or not needed). If needed, the flow continues. I built an…
-
Approval WorkFlow Email showing in comments cell
I have a approval workflow for my team so anyone on my team can approval or decline a request. However in the comment section it is automatically capturing the email the approval is being sent to in the comments. How do you disable this?