Importing Excel Workbook with formula @SUMIF - not working

We're importing workbooks, all formulas are working except for the SumIF and SumIFs.  After reading some of the posts similar to what we are experiencing. We need help since we are unable to make SumIF/s work.  Below are screenshots of the SumIF f...

Jonathan Santamaria
5 |
0
Workiva Sync 답변함

Will Workiva Sync be available for all Workiva subscribers?  Or is it a separate subscription?

Liani Castillo
2 |
0
Exporting links created in Wdesk and retain the link function in excel

We've created links in Wdesk spreadsheets, but we need to retain those link capabilities in Excel, is that possible.  For example, I have a spreadsheet that has a section for table of contents.  Each section is currently linked to a section in the...

Stacey Borgstadt Rising Star
3 |
1
MD&A Cash Flow Flux Formula

Has anyone created a formula for Cash Flow Flux for MD&A?  Like if the change for operating cash flow decreased, it would say decreased or if it was a negative it would be used in vs provided by? 

Permanently deleted user
1 |
0
Sync & Apple 답변함

Our organization would like to adopt Sync using our spreadsheet.  However, we were told it’s not compatible since we using Apple, only compatible with Windows.  Is there a work around using the sync spreadsheet option or will this be available soo...

Cindy Valerio
3 |
0
Ability to export chart spreadsheet

There are times that we have a large date for graphs that are not linked into a spreadsheet. Is there a way to export the live chart spreadsheet as excel?

Permanently deleted user Rising Star Beta Buddy
1 |
0
Proxy/10-K timing - single source sheet

We combined our source sheet and added our Proxy to our workspace during Q4 2022, and after filing last week are ready to begin prepping for Q1. However, our proxy (not yet filed) is connected to our sheet. How do other teams handle this mismatch ...

Jessica Welch
1 |
0
Array Formulas 완료

hello, I can't figure out why workiva is throwing a #VALUE! error for the following formulas:  =IF(ISBLANK($F2),"",INDEX('COA & FSL Mapping'!$B:$B,MATCH($C2&$F2,'COA & FSL Mapping'!$U:$U&'COA & FSL Mapping'!$A:$A,0))) =IF(ISBLANK($F3),"",XLOOKUP(1...

Ashley Moussa Data Management Suite
7 |
2
Character Limitation

Is there a way to limit the characters that can be entered in a cell?  I couldn't find anything on it.  We have a lot of departments entering their justification for new funding and it's creating a massive report, is there a way for them to limit ...

Kyley Houck
4 |
3
FILTER Function Alternative 답변함

Hello. I’m looking for help on the best option in Wdesk worksheet to return all rows (records) based on criteria defined from one sheet (data source) to new sheet. There are several ways to do this in excel and one option that comes to mind is the...

Omar Fernandez
3 |
3
How can we list unique values from a range in a spreadsheet? 완료

Hi, I'm trying to list down all unique values from a column in a spreadsheet. For eg. If I have the below list in the column in a spreadsheet: A. And I want to transform the column so that only the unique values are shown as below: B.   Is there...

Kevueli Tavainavesi Rising Star Idea Generator Data Management Suite
14 |
5
Import of xlsx File Failed 답변함

I am trying to import an .xlsx file and the size is 45,219 KB.  It is failing and I am not sure why.  Has anyone had success in importing a file this size and if so, what can I do to get this to work?  Thanks!

Kellie Volpicelli
1 |
0
Rounding with different dollar values 답변함

I have one document that is in whole dollars and linking it to another document that will be in thousands. During this process, we have come across footing issues. I started using the "round" formula which will allow it foot but came across other ...

Permanently deleted user Workiva Advocate Rock Star Idea Generator Community Champion
1 |
0
Pulling sheetnames into cells

Anyone know if you can use a formula in a workbook to pull in the sheetname?  Say the sheet name is "XBRL," I want a formula that will pull in that text to a cell, then change if I change the sheet name to "Mona Lisa."   Thanks for any thoughts.

Pat Flanakin Community Champion Idea Generator
1 |
0
RRI or Compound Annual Growth Rate (CAGR) Fuction

It looks like Wdesk Spreadsheet doesn't support RRI or CAGR function. Is Workiva bringing this function? Does anyone know workaround function for this formula? Thanks in advance.

Roman Magar Rock Star Idea Generator Train the Trainer Data Management Suite
1 |
1
Pivot Table 답변함

Hi there,  Are there any alternatives way that help in the absence of pivot table to present data on workiva spreadsheet?  Thanks

Cavisen Ramsamy
3 |
1
Superscript formatting within a formula 답변함

I have been unable to utilize the superscript format within a formula. The formula is an if statement that dynamically creates row titles based on the values in other columns (e.g. "realized gains" when all positive amounts vs "realized gains (los...

Eileen Hopton
1 |
0
Cross-spreadsheets formulas 답변함

Hi! I want to use a formula connecting two different spreadsheets. Im trying to use VLOOKUP formula, when I try to select for the table array, a table in another file inside workiva, the formula is no longer active and I cant continue typing. Is t...

CATALINA DANIELA SCHIAVELLI Idea Generator
1 |
0
SUBTOTAL does not allow Function_num that "ignores hidden rows" 완료

Hi, I've been trying without luck to use the SUBTOTAL formula to exclude hidden rows as a useful way to check if my total in the tables of the Financial Statements matches with the total in the Primary File, although I got a error message saying t...

Pedro Andrade GSR Specialization Financial Reporting Solutions Specialization Rock Star Idea Generator Data Management Suite Workiva Essentials
6 |
1
Percentile and Quartile Formulas 완료

I was wondering when we could use Percentile and Quartile functions in Spreadsheets? We use this for our CECL calculations and we want it all to be in Wdesk, but cannot do the entire file in Wdesk until these functions are in Wdesk.

Andrea Hopkins
3 |
2
Need transpose function in spreadsheets 완료

I recently had to transpose roughly 60 columns x 4 rows into 60 rows x 4 columns. While I was able to do this in Excel, I couldn't copy the links from the source data. Transposing in Wdesk spreadsheet would allow me to retain the links to the sour...

Bob Graham Rock Star Idea Generator
3 |
1
Txt. files format

Hello everyone, Does anyone know if Workiva supports txt. format files to update spreadsheet content? Or do I have to convert the txt. file into an Excel file before importing it? What is the best practice recommended? My question is concerning bo...

JULIANA LOBO DE LIMA Data Management Suite Workiva Essentials
1 |
0
Troubleshooting Wdesk Sync Errors

I couldn't find any specific resource to aid in troubleshooting Wdesk Sync, so leaving this here as a future reference for the community; hopefully someone will find this helpful. During our organization's adoption of Sync, we encountered a tempor...

Jon Neufeldt Rock Star Idea Generator
1 |
2
Data Collection Spreadsheet in Certification process 답변함

Hi! We are exploring the possibility of including our 10Q/10K Data Spreadsheet into our certification process so data providers can input and certify the information directly in the system. We will create copies of the tabs so data providers can u...

Zuleima Cordero
1 |
0
custom shading a cell in excel worksheet 답변함

Is there a way to shade the cell a custom color? We want to use company colors when using alternate shading. It does not appear that the function of 'alternate cell shading' has ability to choose anything other than present combinations. But when ...

Hetal Bhuta
4 |
0
Subtotal Features 완료

Hello, I am looking to solve a consistent issue we have on Workvia where hidden rows are still counted in sum/subtotal formulas. One solution would be for us to use Subtotal 109 excel formula as a check to only calculate visible rows, but Workiva ...

James McDowell Idea Generator
3 |
2
Argument to specify Unique values in TEXTJOIN() Function in Wdesk Spreadsheets

I was working in a Wdesk spreadsheet, and I needed to combine cells that contained text into one cell with a delimiter between the text from each cell.  However, some of the cells that I am trying to combine contained repeated text, so I thought i...

Stephen Brillhart Workiva Platform
5 |
1
Change Notification 답변함

Does anyone know if there is anyway to flag a cell if it's value is not zero? we have a checks file and although our team does a good job monitoring the spreadsheet to make sure our differences are zero, we do run the risk of missing one because w...

Jenniffer Vielman-Vasquez Beta Buddy Rock Star Idea Generator Community Champion
3 |
0
Can subtotal formula reflect filtered view? 완료

I have applied a filter to my data, and I am using a =SUBTOTAL(9,...) formula, but all values in the range are included, instead of just the visible values of my filtered data. Is there a better way to do this?

Rory Mulhern Rising Star Idea Generator Workiva Platform Data Management Suite
2 |
1
Confirmation for completed processing

How can I be sure that calculations are processed and completed after a data sheet has been loaded?

Beat Nydegger Rising Star Idea Generator
4 |
4