Select to view content in your preferred language

Connect: Let us break the survey into multiple sheets in the spreadsheet

39
0
Thursday
Status: Open
Labels (1)
AlfredBaldenweck
MVP Regular Contributor

I'm working on a long and complex survey right now.

With calculations, opening and closing repeats and groups, and just general spacing, the entire thing is currently sitting pretty at 403 lines (330 actual lines with things in them).

AlfredBaldenweck_0-1747929873313.png AlfredBaldenweck_1-1747929908139.png

As you can imagine, navigating this is getting very tough. I'm employing strategies such as conditional formatting to show when repeats or groups open and close, which makes it a bit easier to figure out where I am as I scroll, but it's still a struggle.

AlfredBaldenweck_2-1747930098058.png

AlfredBaldenweck_3-1747930111427.png

I would love to be able to break this up into multiple sheets in the workbook.

Even if it was only by page groups (e.g. I have three pages in this survey, so splitting into three sheets), that would be a serious improvement on the current experience.

Please let us organize the surveys more easily.