Sign in to join the conversation:
Can anyone help me figure out how to identify a project status as "Complete" only if all of the tasks in the entire column are complete, or as "In Progress" if there any tasks that are not complete?
Is this the same post as HERE?
Yes, I'm sorry. I have to have this completed today and I wasn't sure which one was faster. Again, my apologies.
No worries at all. I have responded on the other one. We should be able to get you something figured out relatively quickly.
I have tried to set them as Edit - can share, Edit - cannot share, and commenter and nothing works, they cannot add data to the sheet. Does anyone have a solution?
The Issue My project-specific metadata sheets use INDEX/MATCH formulas that reference the Intake sheet using a Project ID. When the automation archives rows from the Intake sheet, these formulas break because they can no longer locate the source data. Example formula: =INDEX({Project Intake Name}, MATCH([Project ID 1]@row,…
Two of my five automation workflows appear to have just randomly stopped performing on April 9, 2026. All others, which would/are performing as normal and would be functioning alongside the other workflows, are functional and appear to be untouched by this 'bug'. Help I've tried all that I can think of.
