Conditional Formatting - Due Dates

Hello, My objective is to apply conditional formatting to due dates in a connected sheet so my team knows which controls are due within the next two weeks. I am struggling to figure out if there is a way to set up a dynamic formula or if my only o...

Katherine Petruszak
6 |
0
Pivot Table in Spreadsheets

It is very frustrating to not be able to create a pivot table in wdesk. It takes way to long to use sumifs formulas to get the results that a pivot table would provide.  I am trying to keep it all in wdesk for audit/control purposes.  Is there any...

Becky Gale
9 |
36
Workiva spreadsheet - symbols - adding more superscripts

Hi, I recently found out that you could add superscripts to spreadsheets via the Symbol function. I was wondering if the superscripts could be done more easily via a superscript function rather than having to go to symbols. If not, was wondering i...

Mandy Tsui
8 |
3
Linking text within a cell without linking the entire cell

Hi, I want to link the date and amount in the following cell from our single source file. When I try linking them, they don't appear as destination links. Does Workiva have the capability to link text within a cell without linking the entire cell?

Corina Chan Rising Star Idea Generator
10 |
0
Add images to Excel 완료

I am currently unable to insert images into the Wdesk version of Excel. Images saved in an Excel document do not upload into the Wdesk version of Excel. 

Permanently deleted user Rock Star Idea Generator Community Champion
9 |
7
Spreadsheet cell limits 답변함

How do the cell limits work in Spreadsheets? I understand that there is a limit of 2,000,000 cells in Spreadsheets but I was wondering what counts as a used cell. Is it 2,000,000 cells containing any data or do empty cells count towards the limit ...

Carl Hills
9 |
2
Uploaded excel file, but available for download only? 답변함

I uploaded an excel file without pivots or external links, yet it "is available for download only." How can this be fixed so I can upload the file and be able to edit it within Workiva?

Fernando Montanez
3 |
1
Rounded figures - calculations

We have calculations using figures that show up multiple times at varying scales, so they're entered in the spreadsheet in whole dollars and historically the difference calculations are based on that information, then linked and formatted in docum...

Nicole P. Rock Star Idea Generator Community Champion
2 |
0
CHILDREFS & TEXTJOIN Data Aggregation FAQs

This post helps explain how you can use CHILDREFS and TEXTJOIN in formulas for data aggregation. Examples and supplemental information is also provided.  A common use of Spreadsheets is to aggregate data across a changing number of sheets. Each ti...

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

CHILDREFS is only available in Spreadsheets. Formula help will not suggest CHILDREFS when creating formulas in embedded tables. Formulas containing the CHILDREFS function will evaluate to 0 if pasted into an embedded table. This is because there...

Mike Davis Community Manager Amplify Attendee Community Champion Idea Generator Data Management Suite Workiva Essentials Train the Trainer
0 |
1
Advanced Example: Nesting CHILDREFS Formulas

Nesting CHILDREFS formulas in child sheets enables multi-level data aggregations. In this example, “North America” contains SUM/CHILDREFS formulas aggregating values from its child sheets, “California” and “New York”. By demoting “North America...

Mike Davis Community Manager Amplify Attendee Community Champion Idea Generator Data Management Suite Workiva Essentials Train the Trainer
0 |
0
Advanced Example: Combining CHILDREFS usages

You can include the CHILDREFS function more than once in a formula. This enables you to compound aggregations from different parent sheets all in one formula.  In the above example, the North America sheet is a sibling to the “NII Summary” sheet...

Mike Davis Community Manager Amplify Attendee Community Champion Idea Generator Data Management Suite Workiva Essentials Train the Trainer
2 |
0
How to use CHILDREFS

CHILDREFS is more than a formula - it's a function you add to formulas to invoke data aggregation. Adding CHILDREFS to your formula tells the formula to apply the cell reference to all sheets that are children to the current sheet being edited in ...

Mike Davis Community Manager Amplify Attendee Community Champion Idea Generator Data Management Suite Workiva Essentials Train the Trainer
0 |
1
Conditional formatting that will lock a cell as well as make it blank 답변함

We are working on a if/conditional formatting situation-where we want it to be  if No then should be blank and lock the cell for editing. Is that something that can be done currently in spreadsheets?  Also is there conditional formatting that will...

Tanya Thomas All Star Idea Generator Community Champion
1 |
3
Filters in a Spreadsheet Template 답변함

Is it possible to add filters to a spreadsheet template and have those filters carry over to the spreadsheets created from that template? I've tried to do this myself and the filters did not carry over to the newly created spreadsheet.  While it i...

Maria Bishop Idea Generator
1 |
0
Conditional Formatting to highlight the largest number in a column 답변함

I am trying to create a conditional format for each column to identify the record amount for that specific column.  We want the record cell to be highlighted green and bolded for the largest value.  I am not sure how to do this and could not find ...

Bryant Voiles
2 |
1
Connected Spreadsheet Rollforward

Hi CAB members! My team is using a connected spreadsheet between two workspaces and we are looking for best practices for how to rollforward. Right now it looks like when we rollforward we have to reconnect the spreadsheet in each workspace. That ...

Christie Kozlik Rock Star Idea Generator Community Champion
11 |
4
Tips for streamlining spreadsheets

Hello - I am looking for any tips, best practices, or success stories of folks using spreadsheets successfully for financial reporting disclosures in Wdesk. Are there testimonials posted elsewhere in the Community or any helpful videos from an Amp...

Drew Dunn
1 |
0
Setting Page Margins in Spreadsheets? 예정됨

Is there a way to adjust the standard 1" all around margins on a PDF created from a spreadsheet?  My worksheets that should print on two pages are stretching over four because the margins on the PDFs are huge.  Changing the orientation from landsc...

Sarah Gorman Rock Star Idea Generator
23 |
15
Spreadsheet - Dragging Cells 완료

We recommend that their software engineers create spreadsheet functionality to allow us to select certain cells and drag (move) them to other cells. To be more clear, we're asking for functionality similar to Excel where we can drag a cell (or mul...

Tremain Crutcher Rising Star Idea Generator
4 |
3
nützliche Funktionen im Spreadsheet (Gruppieren, fixieren)

Guten Tag, für ein übersichtliches Arbeiten im Spreadsheet finde ich es hilfreich über zwei folgende Funktionen zu verfügen: > Gliedern (Gruppieren) von Daten in einem Arbeitsblatt bzw. einfügen von Ebenen.  > Fenster fixieren: Die fixierte Spalte...

Tanja Wilfert
1 |
0
Shorter dash for zero linked value 완료

Would it be possible to have the option of amending the dash from the 'Em dash' to 'En dash' in a linked cell when the value is zero? Currently only the 'Em dash' is available and this is very long and does not match our required formatting.

Mikaela Lehvonen Rising Star Idea Generator
9 |
3
External links in Imported Excel formulas

Hi, I Imported an Excel file (.xlsx) into a Wdesk Spreadsheet with cells linked to other files saved in my local PC. Workiva shows the imported cells with #SHEET in spite of keeping the link to my locally saved files. Is there any other way to kee...

ibon Clavero clavero ugarte
2 |
0
Has anyone successfully used a SUM(SUMIFS) formula in spreadsheets? 답변함

I imported a spreadsheet into Wdesk and it has SUM(SUMIFS) formulas all over the place, but I can't seem to get them to work in spreadsheets.  So currently I have #VALUE in all the cells.  Does anyone know if Wdesk supports the use of this formula...

Kellie Volpicelli
8 |
2
Leading zero in tables 답변함

Hello, Is there a way to show the leading zero in a table? I'm trying to display "0408" but it keeps returning "408" even when I use excel files tricks it doesn't work. Thanks. 

Sean Manning
12 |
1
Copying one sheet in a spreadsheet to another spreadsheet 완료

We would like to create one combined spreadsheet for our quarterly and year end reporting. What is the best method in Workiva Next Gen to copy portions of our quarterly spreadsheet file to another spreadsheet (e.g. year end spreadsheet)? Thank you.

Jill Yaspan
2 |
1
Add support for XLOOKUP formula 완료

The following enhancement was shared by a Workiva user: We are really excited for this new formula in Excel and wants to know if we would consider adding it too. https://techcommunity.microsoft.com/t5/Excel-Blog/Announcing-XLOOKUP/ba-p/811376 I...

Mike Davis Community Manager Amplify Attendee Community Champion Idea Generator Data Management Suite Workiva Essentials Train the Trainer
18 |
13
Using if/then for images

We have a document that we would like to use if/then statement to show an image depending on whether or not a criteria is met. So if the criteria is met we would like to show yes/no with a circle around yes and if the criteria is not met i would l...

Jenniffer Vielman-Vasquez Beta Buddy Rock Star Idea Generator Community Champion
1 |
0
Concatenate & Text Formula - Parenthetical Text 답변함

I am attempting to add a decimal place into the parenthetical text in the comprehensive financial statement. It appears correct for anything that isn't a zero, where it just leaves the value blank (see column A below). Any suggestions on how to fi...

Murphy Sauceman Beta Buddy Rock Star Idea Generator Community Champion
2 |
0