Spreadsheets
Sumproduct formula with multiple criteria Udzielono odpowiedzi

Hi, i uploaded the files where i use this formula: =IF(B4=0,0,SUMPRODUCT(--('2017 YTD'!$B$133:$B$1000">="&B1),--('2017 YTD'!$B$133:$B$1000"<="&B2),'2017 YTD'!$E$133:$E$1000)/B4) However, it doesn't work. Does anyone know if this formula supported ...

Yulia Oleynik
40 |
4
Spreadsheets
Concatenate Formula and Fonts Udzielono odpowiedzi

When using the concatenate formula to combine cell text, is it possible to keep the cells format? For example, when combining the Footnote number and Footnote Description, can you keep the Number as regular font and have the Footnote Description I...

Breanna Giacalone
1 |
0
Wdata
WDATA Data Integrity Udzielono odpowiedzi

Hi,  A little late to the party but one thing I'm not sure about as someone who's team hasn't adopted WData yet is how does Wdata prevent the need for running reports from the general ledger system to check and verify that wdata is pulling the cor...

Anthony Miller Rock Star Idea Generator Community Champion
1 |
0
Spreadsheets
Blank Accounting Cells Filled with Zero Udzielono odpowiedzi

We have transitioned several files into Next Gen which have blank cells with the accounting data type. The transition added zero to previously blank accounting cells which messed with some formulas in the same document. How can I transition these ...

Justin Azer
1 |
0
Spreadsheets
Down adds on hidden rows Udzielono odpowiedzi

Is there a way to check down adds (instead of using a calculator to ensure there are no hidden rows in the column you are adding) so you can tie to the total displayed? Same would go for cross adds. 

Grace Anlian
1 |
1
Chains
Download query result - unknown error Udzielono odpowiedzi

When running the chain for the "Download query result" step, I am receiving the below error. Any idea on how to remedy this?

Lauren Thompson Idea Generator
3 |
0
Linking
Placing a link to a Document within a Presentation Udzielono odpowiedzi

I am creating a presentation and would like to know if I can place a link to a document within the presentation? Basically, I want the person reading the presentation (who does not have permission to edit the presentation or document) to select th...

Kimberly Ashley
5 |
0
Controls Management
multiple test forms for the same control Udzielono odpowiedzi

Hi, Here is the scenario:  - One standard control (say CTRL-5) that is applicable to multiple legal entities (say 10 entities)  - we need to test the control for each legal entity and there are two test phases: Interim and Year-end i.e. total 20 t...

Anit Jain
9 |
0
Documents
Tab stops in Next Gen Document tables? Ukończone

We recently transitioned the bulk of our documents to Next Gen, and are adjusting some tables to deal with the forced page break if the margins are different in section-to-section. It doesn't appear that tab stops are currently available in a tabl...

Megan Butler Workiva Advocate All Star Idea Generator Workiva Platform Community Champion
7 |
1
Home & Files
Folder Permissions? Udzielono odpowiedzi

Sorry if this has been addressed somewhere else! Given that the Project concept is going away in Next Gen, is there anything in the pipeline about setting Permissions at the Folder level?  As a user that carries forward a "primary spreadsheet roll...

Stephanie Barnhart Rising Star Idea Generator
10 |
2
Filing & Section 16
Saving a combined PDF file in Next Gen Udzielono odpowiedzi

A functionality I loved in Wdesk classic / projects, was that at any point I could save a PDF ready file and actually include all documents (if contained in a project) into 1 combined PDF file... LOVED IT! However, as we move to Next Gen, there ar...

Jonathan Gregory All Star Idea Generator Community Champion
8 |
1
Change Management
Freezing a Presentation

Is there a way currently to freeze a presentation, document, or spreadsheet from updating links when something is final.  For example, if I were to roll forward a presentation (month x +1) that is linked to a spreadsheet with Wdata, I have to pres...

Hunter Jones
1 |
1
Documents
Next Generation- locking sections

It doesn't seem like you are able to lock sections in Next Generation like you could in Classic. Are there other things that can be done if you want to be in a section and make changes without anyone else being able to make changes as well?

Katherine Kline
8 |
0
Presentations
Presentations over Document Udzielono odpowiedzi

We are currently using document for all our reporting purposes (internal and external). I wanted to know what is additional in presentation which is not available in document.

Arihant Bengani All Star
1 |
0
Chains
Auto Refresh A Connection to a Query Through WData? Udzielono odpowiedzi

HI there - through chains I can automatically run a query every day. This same query is connected to a Spreadsheet.  Is there a way to have the spreadsheet automatically refresh each time the chain is run to run the query? This way, we dont have t...

Bradley Coleman All Star
9 |
0
Controls Management
"Remind all" for overdue PBC requests?

Please consider adding a "remind all" function that allows a click of one button to remind folks who have overdue PBC requests. Having to click and remind one at a time is super frustrating and it is not easy to tell which you have reminded and wh...

Rebecca Demy Workiva Advocate Beta Buddy Idea Generator Community Champion
4 |
2
Change Management
Locking data in spreadsheets to avoid editing Ukończone

I am trying to prevent any editing to a spreadsheet that is linked to a filed document.  In Classic, there is an option to freeze all filed documents, but I can't seem to find anything in next gen.  I see that there is something called "locked" fo...

Barbara Beta Buddy Idea Generator Data Management Suite Community Champion
4 |
0
Documents
Send Reviews to Workspace groups Ukończone

In NextGen, are you able to send reviews to an established workspace group (as opposed to selecting each individual person to send a review copy to)?  I would like to send certain sections of a document to certain reviewers, and a different set to...

Kat Meadows Beta Buddy All Star Idea Generator
4 |
0
New to Workiva
What would you like to learn?

What are you looking to learn more about? We’d love to hear your thoughts! Simply add your comments below and vote on any other comments too.

Mike Davis Community Manager Amplify Attendee Community Champion Idea Generator Data Management Suite Workiva Essentials Train the Trainer
2 |
0
New to Workiva
What’s your favorite feature?

What feature helps you be more effective in your day-to-day that you wish someone told you about sooner. Feel free to share in the comments below, and vote on any others too.

Mike Davis Community Manager Amplify Attendee Community Champion Idea Generator Data Management Suite Workiva Essentials Train the Trainer
1 |
0
Chains
Tables with Variable number of rows Udzielono odpowiedzi

Hi There - I have simple CSV file with a few columns of data on a securities portfolio.  Each row is a separate investment security.  Each month end the total number of securities changes (and therefore the number of rows changes).    I created a ...

Bradley Coleman All Star
2 |
0
Controls Management
Search files in Audit Form

In the External Audit Form, files are uploaded to the sub-procedure under different procedure (i.e. Audit Planning, Audit Mobilization etc.). If I don't know whether certain file is uploaded into Workiva, is there a way to search the file without ...

Lin Fang
2 |
1
Documents
Non-Printing Characters Rendering in Edgar Udzielono odpowiedzi

I am getting started in Next Gen documents and have noticed that hard returns entered into cells within tables (so that I am effectively wrapping text where I want it to break into two lines) are showing up as a weird icon that says "LSEP" in Edga...

Maureen Ebbs
3 |
0
New to Workiva
Growing with Workiva

https://workiva.wistia.com/medias/9jhafd4ify Explore inviting people into your Workspace to collaborate and save time! Looking for Features that Promote Growth?Get Ready to Level Up walks you through taking advantage of new features with links to ...

Mike Davis Community Manager Amplify Attendee Community Champion Idea Generator Data Management Suite Workiva Essentials Train the Trainer
0 |
0