-
Is there a way to see all recipients of an alert within the automated alert email?
I have created a Smartsheet which will sent automated alerts to multiple people. Everyone getting an alert is just seeing his/her name in 'to' but not the other names. So the person does not know who is informed as well. Is there a way to change it so that every recipient sees to whom the alert has been sent?
-
Tracking that project has an update or not
I have a project tracker for my entire team with very simple information as it is a very high level overview of all active projects. My CEO will be checking the information weekly so I planned to do a Weekly Update Request that goes out to my team to 'remind' them to add any updates to their projects. Since some of these…
-
=INDEX =MATCH to pull up dates.
Hello, I've been wracking my brain trying to understand why this doesn't work. I have a sheet with some project-related data including the columns "START DATE" and "END DATE" which are date columns because they have dependencies on the duration column etc. I'm making a new sheet for resource allocation, and I need to bring…
-
Process with parent row
Hello, i have a sheet with all quoatation i sent to client and some of them moved to status "approved"/"void". the process is after i get the PO, and after i finish the job that the client buy from me i forward request to my worker for issue a invoice. i have the summary for all quotation i sent where now is it (waiting…
-
Automated workflow (email alerts) stopped working
I have a number of automated workflows set up to send alert emails that are no longer working. They were previously working fine for days (and I tested them repeatedly), but they have all of a sudden stopped. I haven't changed the automation and the sheet is locked, so no one else could have either. Is anyone else…
-
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)))"…