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