-
Workflow Triggering at Random and Not Scheduled Time
I have an interesting issue with one of my workflows. Everything about it works correctly except the trigger. If a ticket is in New status, it sends an automated email to a user letting them know that they will be assisted shortly. If it is in one of the four open statuses, it sends an approval request to the user, asking…
-
AUTOMATE PROGRESS BAR BASED ON MULTIPLE CONDITIONS
Hello, I am trying to automate my progress bar, basing it's progress on multiple conditions. I have 10 columns I would like the progress bar to consider. Example below of how i would like it to work: If Cost 1 AND Hours 1 IS NOT Empty then progress = 25% If Parts AND Survey AND time IS NOT Empty then progress = 50% If…
-
Automation triggered to send to contacts in a cell, but it's still sending to me.
I have an automation set up so that when a rows are added or change and a box is checked it triggers the automation to send to contacts in a cell. However, I keep getting notifications sent to me for one of the triggers, but my email is no longer listed. I wanted to test my automation with my own email first to make sure I…
-
Assigned to // Contact List
Hi all, I have an equipment tracker sheet that has an Assigned To column set as Contact List. I came to realize that regardless this sheet is not shared with them, they are able to change/edit/modify the cells of this tracker sheet. I don't want anybody to edit those cells except the ones that are already in the shared…
-
Reference cell in column on one sheet, against column on another.
I am trying to create a formula thagt will look at the "Item Name" columns numbers, and then check to see if any instance of that number appears in a column on another sheet, and if it does return "True", and if it doesnt return "False" I've had a similar equation in excel "=NOT(ISERROR(MATCH(A2615,'Up-To-DateLK'!A:A,0)))"…
-
How can i archive workspace?
So we have created sperate workspace for different projects. And we would like to archive that workspace once the project is done. Is there anyway we can archive it? If not, any other solution people are utilizing? Appreciate the help :)
-
I'm just stumped on this date function. Can someone help me please?
I have a sheet that is tracking projects for our team. I have one column that is "Asset Due Date" and I want another column "TD Due Date" to auto populate a date that is 28 days prior to the date chosen for "Asset Due Date". Both columns are set up as date column types. I've played with the date function and just can't…
-
Links to Attachments
How long does the link to an attachment in an automated email last?
-
Workflow in Parallel not sequence
To limit the amount of workflows, I was hoping to create a workflow that has 1 trigger but many actions that happen at the same time. Rather than waiting for the pervious one to happen. Currently my workflow looks like the brown example, and only sends the first request all the way at the left.
-
Error: Trigger Alert Someone workflow on a daily or weekly basis.
Can someone explain to me why this automation works: But this automation throws an error: The error occurs when I try to change the trigger to "daily" or "weekly". The error is as follows: According to this smartsheet article, there should be no problem with this workflow: Trigger frequent, change-based automations in…
