Hi Team, I have a datafile which has some values embraced within quotes like "ABC" and am trying to do Unpivot over this data file. Getting the error as below. Error executing command: parse error on line 9289, column 161: bare " in non-quoted-f...
I'm building a chain to automate pushing updated query results to a spreadsheet. I'm encountering an error in the Overwrite Sheet Data node that I can't solve. Please see structure of the chain below: Below is the error I am receiving: 🔌 Work...
That's a wrap! Thanks for making Amplify 2021 a great success. We hope you enjoyed each and every minute. To access the content on demand, go here. For slides, on each session page they will be updated at the very bottom. This content will be avai...
I have a spreadsheet open that has no filters applied, the row count is 2728 rows. Only 702 rows are showing and it says there is 702 rows that match filter. I do not have any filters applied so I do not understand why I cannot see all 2728 items?
We have had a lot of issues with configurability in the legend, which has kept us from using them in a number of our charts. I discussed this with some developers at Amplify and thought we might be able to implement some changes. Unfortunately I'm...
We are looking to using the SAP Hana connector to load interface files being transformed in wdesk, is anyone currently using the SAP Hana connector for this or something similar?
I have a file with these contents: AJE Number,Fiscal Year,Bucket Code,Balance Type Code,AJE Type,Comments 2020-001,2020,A1,ACT,NORM, ,,,,, I am trying to remove the empty row so I have a Filter Rows command as per: Command: Filter Rows Search pa...
I would like to be able to print out a complete log of a "Process" for SOX control purposes. When I attempt to export a CSV file under "Activity" in the Process document, the download only includes activity assigned to me and does not include any...
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...
TEXTJOIN is a newly supported formula which allows you join text strings in different cells together. CHILDREFS can be used with TEXTJOIN to join text from cells across all child sheets. In this example, the TEXTJOIN formula “=TEXTJOIN(", ",TRUE,...
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...
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...
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...
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 ...
Date Tuesday, September 28, 20212:00 - 3:00 p.m. EDT WATCH ON DEMAND Details As summer comes to a close, so does the quarter. The SEC Professionals Group, sponsored by Workiva, continues their 10-Q prep series by welcoming back Alyson Clabaugh...
Es necesario que al linkear un texto de un documento al texto de otro documento se copien y generen las notas al pie. English translation: Creation of footnotes when links are made between two textsIt is necessary that when linking a text of a doc...
And now, get ready for Amplify EMEA with the general session starting at 10:00 BST today! EMEA attendees are set to experience all the fun things like the rest of the geographies, from 1:1 meetings with Workiva experts and sponsors, and 70+ sessio...
While there has been significant improvements in the Presentations tool over the last couple of years, we’d like to see other capabilities similar to what’s offered in PowerPoint. Maybe these suggestions are already documented but I'll risk offer...
Amplify in the Americas officially kicks off at 11:00 a.m. ET today! The opening general session: The Platform for Simplification will feature inspirational stories from champions, like Upwork, who’ve transformed the way they work for the simple...
This blog appeared on Workiva.com on Sept. 16, 2021. There’s always been something about Workiva customers that gets me. I saw it in the stories on the website before I was even hired. I see it first hand in my work with user groups, customer pane...
Apologies if I missed this in already-existing support guidance, but I wanted to check in to see what, if any, non-Workiva files we can obtain from others as part of the new processes option. For example, instead of formally opening up a section ...
Typically we put the change in line items in our MDA in the document. Is it better to do it in the document or in the spreadsheet
We're excited kick off the pre-conference day for the Americas. The SOX & Internal Controls Professionals Group Summit starts at 2:00 p.m. ET today! As part of Amplify, all attendees can catch all this—even if they’re not a SOX Pro Group member (y...
This blog originally appeared on Workiva.com on Aug. 25, 2021. Written by Chuck McMurray. Let’s talk about everyone’s favorite subject: rounding. Exciting, right? Well, it is a lot more exciting now—not to mention exponentially easier—with Workiv...
If I make a copy of a document to use as a template for the next period (i.e. I copy the 2nd quarter 10-Q and then use that copy for the 3rd quarter 10-Q), it makes an XBRL profile with a name stating that it was copied. This copied XBRL profile ...
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...
How do you get a hyperlink to link within the document, but not appear as a hyperlink for document printing purposes?
We are creating XBRL tags for the FERC footnotes and linking them to the spreadsheet. The question I have is for my boss that tagged them, they show as yellow and show with the yellow triangle. I am looking at the same item, and that yellow does...
Hi Team, I am using Command Group Iterator to read(Get sheet Data) and to write(Write sheet) into a spreadsheet. Output of these commands are "Value1, Value2, Value3... ValueN". Instead of this, I want to rename these values as sheet names. Ca...
Hi, Was wondering if there's a best practice for image compression for adding images to wdesk presentations? It doesn't seem like there is currently a way to compress images directly within workiva so was wondering if there is an estimated ppi or ...
Big news for your Scope 3 reporting! Hybrid Calculation Method V2 is now live in Workiva Carbon for Categories 1 & 2, delivering higher data quality thresholds, direct insight into raw CDP source data, and flexible version control across your repo...
Have a suggestion to share but not sure if it pertains to Reporting, GRC, Filing or other? Look no further! Below is a breakdown of the existing feedback topics and what product/feature area belong in each. API & Developer Feedback Ideas and sugge...
Did you know that over 1000 ideas have been shared in the Workiva Community? The odds are high that the idea you seek has been requested before. Here’s some tips to help you find what you are looking for so you can weigh in too! First, search for ...
Back again by popular demand, check out the 2026 SEC Filing Deadline calendar below. This calendar includes SEC holidays when the EDGAR® system will not receive, process, or accept submissions. As a reminder, filers will need to comply with ASU 20...