|
Classic file types are no longer available for use as of January 2021. You can transition your classic files or download a PDF. Learn More

Range linking with hidden rows

Answered
Request Demo
Related to Spreadsheets linking

Hello, 

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

0

Comments

1 comment

Date Votes
  • Isabel Messore

    Hi Markus Rechberger, 

    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 readers
     
    This approach will replicate the conditional row hiding behavior you want at the document level!
    0

Please sign in to leave a comment.