Hyperlinking in Spreadsheets 답변함

Is it possible to have the hyperlinking functionality in Spreadsheets to function similar to Documents, where it's possible to link to a specific section? Currently, I believe you can only link to a web address, which works initially, but now that...

Kyle Panos Beta Buddy Rising Star Idea Generator
21 |
12
Spreadsheet filters 완료

Excel has the =filter function which allows you to filter a range or an array.  You can use it to return multiple rows based on a value or values. For example, from your current sheet you could return all rows from a connected sheet where "FY2020"...

Greg Barnard Workiva Advocate All Star Idea Generator Community Champion
5 |
2
Table -> Multiple Row Insert Functionality? 완료

In the NexGen editor, is there a way to insert multiple rows in a table after the initial table is inserted?  The standard table comes with 10 rows, but there are times I would need 35+ rows. (For example, building out a compensation table in the ...

Peter Molnar Workiva Advocate Rock Star Idea Generator Community Champion
3 |
1
Find & Replace All in Spreadsheets 완료

Is there any timeline on when the Find & Replace All feature will be available in Workiva spreadsheets? Currently the only option is to find and replace, and this has resulted in our team having to manually find and replace for several thousands o...

Kevin Weyant Idea Generator
49 |
43
Ability to Lock Column Widths in Next Gen 예정됨

Hello - is there any way to lock the column widths in Next Gen spreadsheets as well as tables in Next Gen documents?  Users are changing them on us and we do not want that.

Shawn Tays All Star Idea Generator
1 |
1
Best Method - Single Source Spreadsheet to multiple Documents for Next Gen 답변함

Hello, I'm looking at ways to improve setup for our documents and spreadsheets. We have 2 separate spreadsheets (Financial Statements and MD&A) linking to the respective documents of the same name. How can we set up a single source spreadsheet and...

Linda Lo All Star Idea Generator Community Champion
2 |
2
"Transpose" option when pasting information 완료

The following feature enhancement was suggested by a fellow Workiva customer. If you too would like this feature, vote it up or let us know in a comment below and we’ll get your feedback connected to our Product Team as well. I would love to s...

Mike Davis Community Manager Amplify Attendee Community Champion Idea Generator Data Management Suite Workiva Essentials Train the Trainer
16 |
32
Copy and paste images in spreadsheets 완료

Be able to simply copy (CTR-C) and paste (CTR-V) a screenshot in spreadsheets (similar to the capability in presentations) for support backup purposes. The current way of attaching a screenshot has too many steps and you can't easily visually...

Mike Davis Community Manager Amplify Attendee Community Champion Idea Generator Data Management Suite Workiva Essentials Train the Trainer
14 |
42
Authorship in spreadsheets - filtering and updating by multiple users 답변함

When multiple users are in a spreadsheet to make updates at the same time, users are encountering issues when trying to make edits when one user has the file filtered. Is there a way that multiple users can sort the same file at the same time and ...

Kristin Esbrandt
1 |
0
Calendar/Date Selector as Data Validation option 예정되지 않음

Is there a way to either use Data Validation or Conditional Formatting in a spreadsheet to have the end user select a date (like from a calendar)? 

Scott Paasch
2 |
1
Is there a way to insert symbols in a spreadsheet 답변함

Is there a way in a spreadsheet to use tick marks. For example, arrows, lines, symbols.. When creating a tie-out of a footnote, it would be useful to have the spreadsheet set up with the tick marks for ease of exporting to a PDF. We can change the...

Cheryl Portesan
8 |
1
Trial Balance 답변함

Any plans create a feature to upload a trial balance or financial statements to WDesk in order to map internal controls to FSLI's? 

Dustan Nalder
1 |
1
Array Formulas 완료

Does Workiva support array formulas in the spreadsheets? I uploaded an excel workbook that uses array formulas and I cannot seem to get my formulas to calculate in Workiva.

Joey Estrada Idea Generator
35 |
12
Create and Send for Review Spreadsheet 완료

Is it possible to create and Send for Review on Spreadsheet? Also, create blackline? 

Roman Magar Rock Star Idea Generator Train the Trainer Data Management Suite
8 |
6
Sumproduct formula with multiple criteria 답변함

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
Using Formulas vs. Links 답변함

When you have a link, you have the option of clicking the paper clip to direct you back to the source.   For a formula, is there a shortcut to accomplish this?  In Excel, if you hit "Control + [ " it brings you back to the source of the formula.  ...

MICHAEL LIEB
5 |
0
Sum IF wildcard 답변함

Would anyone know anyway to do a sum if wild card formula similar to Excel formula below in spreadsheets?    =SUMIF(RANGE,("text"&"*"),SUM_RANGE)

Accounting Department
3 |
0
XIRR / XNPV Calculations 완료

Has anyone found a work around for XNPV / XIRR functions? Need to run calculations on even distributions. 

Jose Torres
12 |
2
Set default font in Spreadsheets 답변함

Hi,   Is there a way to set a default font in Spreadsheets similar to setting the default in Excel (for example, I want my font to default to Times New Roman rather than the Arial that is currently defaulting to.   Thanks!

Emily Wirsing Rising Star
3 |
0
Is there a way to set the pdf margins in a spreadsheet 예정되지 않음

Is there a way to set the margins when converting a spreadsheet to a pdf? I have a spreadsheet that will fit on a letter sized page if I was able to change the margins. It is cutting off the border on the sheet. I has an inch margin all around and...

Scott Paasch All Star Idea Generator
9 |
1
Conditional Formatting 답변함

Is there a way to set up a conditional fomat when the adjacent cell contains a specific value? In my example below I want cell H2 to be highlighted when cell G2 contains an * or any other value that I choose.

Scott Paasch All Star Idea Generator
3 |
0
Is there a way to automatically refresh filtered data in a spreadsheet or document? 답변함

I have a table of data in a spreadsheet. I want some records to appear in one section of a document and other records to appear in other sections of the document. I accomplished this by linking the entire data table to each section of the document...

Gabe M Community Champion Idea Generator
12 |
5
Restore spreadsheet 답변함

After uploading a worksheet from Excel, the Workiva spreadsheet read some cells that did not have values and then overlayed some formulas I had that were only in the Workiva spreadsheet (the excel file is used only as a data input and formulated v...

Isabella Ho Rising Star
3 |
0
Transition cross-sheet Workbook links to cross-sheet Spreadsheet formulas 답변함

When transitioning a workbook to a spreadsheet, I am presented with an option to "Transition cross-sheet Workbook links to cross-sheet Spreadsheet formulas." What does this do? I am not 100% confident that I understand the description of this chec...

Chad Zenisek All Star Idea Generator Community Champion
1 |
0
Can page breaks be inserted to workbooks or spreadsheets? 답변함

Can the print area of a workbook section or spreadsheet be edited with page breaks?When I save the section as a pdf, I want two pages of information instead of the one.  The easy solution would be to split the information into two sections.  Howev...

Joseph Lopez
14 |
0
Why can't dates concatenate in Spreadsheets like workbook 답변함

why can't we concatenate two cells designated as dates in spreadsheets like workbook? I'm working on transitioning to spreadsheets and the i'm trying to create our dates page. I cannot concatenate two cells so produce the output "September 8, 2018...

Caroline Hemmer Sand
3 |
1
Is there a way to sum only visible rows? 완료

We've set up our data collection templates to include all rows/categories in a table that could have values.  However, many tables have rows that may be zero on a given quarter.  rather than breaking links to the DC templates and deleting the rows...

Ben Andrews Idea Generator Community Champion
27 |
5