Range linking with hidden rows
BesvaratHello,
We've just started implementing workiva and are considering the best way to link our spreadsheets to the document.
In our spreadsheet, we hide or show rows, for example, depending on whether they are 0 or not. We’d like to automatically apply this setting to the document. So, if we hide a row in the spreadsheet, it should also be hidden immediately in the document.
Is there a way to set this up in Workiva?
A similar request was already made about a year ago.
https://support.workiva.com/hc/en-us/community/posts/31168895523604-Range-linking
Thanks
Markus
-
As you may have noticed, hiding/unhiding rows does NOT flow through range links. Currently, row hide/unhide behavior is not automatically carried over from the source spreadsheet to the destination document via range linking. This is a known platform limitation but there is an existing feature request I can add you to!
The recommended workaround is to use a helper column and filter:1. Add a helper column in your source spreadsheet (e.g., a formula that returns 0 or 1 based on whether a row should be shown or hidden)
2. Include that helper column in the range link so it flows through to the document destination
3. Apply a filter on the document side using that helper column's values to show/hide rows dynamically
4. Hide the helper column in the document so it's not visible to readersThis approach will replicate the conditional row hiding behavior you want at the document level!0
Dear Isabel,
yes please add me to the feature request so i will be up to date.
Thanks for the workaround. This lets us hide the rows semi-automatically.
If I change the value in a row from 1 to 0, the row remains in the document until I click “Apply Filter.”Kind Regards
Markus
0
Hi Isabel Messore,
Could you please add me to this feature request as well? I would greatly appreciate seeing this functionality become available in the near future. 🙂
Best regards,
Marion0
Kommentarer
4 kommentarer