Sign in to join the conversation:
Can someone help me understand the why the yellow colored rows are showing up? And how to fix it? I think it has something to do with dates but cant seem to figure it out. See the attached screen shot. Thanks much.
It's possible that someone has set a formatting rule where when some behavior happens it will auto highlight the entire row in yellow. If you click on the formatting icon in the tool bar you can verify if a rule was set.
Tania-
Thanks so much! That was it. All fixed!
That would be my suggestion. Conditional Formatting appears to have been put into the sheet.
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.
