-
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)))"…
-
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 :)