Hello everyone,
I'd like to suggest a new automation action: "Collapse Row" (reduce/fold a parent row).
Use Case:
When managing projects with parent/child row hierarchies, once a parent task is marked as "Complete" (or any defined status), all its child rows become irrelevant for day-to-day tracking. Currently, there is no way to automatically collapse these parent rows — users must do it manually, which becomes tedious on large sheets with dozens or hundreds of task groups.
Proposed Feature:
Add a new automation action — "Collapse Row" / "Expand Row" — that could be triggered like any other action in a workflow. For example:
- Trigger: When a cell value changes
- Condition: Status column = "Complete"
- Action: ➡️ Collapse the row (new action)
Benefits:
- Keeps sheets clean and focused on active work
- Reduces visual clutter without deleting or archiving data
- Improves navigation on large project sheets
- Saves time for project managers managing multiple task groups
Current Workarounds (limited):
- Saved filters (hides rows entirely rather than collapsing)
- Reports (separate view, not in-sheet)
- Manual collapse (not scalable)
None of these replicate the simple, in-sheet experience of an auto-collapsed parent row.
Thank you for considering this enhancement!
