Excel Indirect function
PlaneadaI would really appreciate the functionality of the Excel Indirect function in Spreadsheets. It would allow elements of a function to be variable based on something outside the specific cell with a formula.
-
Hi Bob Graham
I will set up an idea ticket for you to track progress on this functionality.
We appreciate your feedback!0
Hi, has this been developed yet?
1
Hi Samantha,
Our product team is still in the process of looking over this idea ticket.
Please check this thread in the future for the status/progress of the ticket.
Thank you!
0
We would also appreciate to get that function in Workiva!
1
I wanted to inquire if the INDIRECT excel formula function has been added to Workiva?
0
The INDIRECT excel formula has not been added to Workiva yet. However, it is on our roadmap and planned for Q2!
0
hi, given INDIRECT function is not available yet, would you know a work around? i am trying to write a formula to lock a cell in another sheet, but it just cannot be kept dynamic. for example, we have two sheet1 and sheet2, sheet2 has column A , column B, and column C, every quarter a new column is inserted on the left to add a new quarter, but in sheet1 we want to always refer to column A even though it is a new column, with indirect we can easily realize that, do you know any other way to realize it? (we cannot use sheet2$columnA as it will shift to sheet2$columnB after a new column is inserted in sheet2 on the left). thanks very much.
0
You could try using Index and Match if your columns have a date header. Then you would just have to have something that changed the date each quarter. You could even compute that by looking at the "Max" of the row with the dates at the top of the columns on sheet2.
0
Hi Isabel Messore, just checking in on the progress of this item.
Noting this was on the roadmap / Q2 plan per above, do you have any insights on when we can expect to see it active?
If there is a feature ticket, please add me to it to track updates. Thanks a lot!0
Hi Jason Kotze,
This does remain a top item for our feedback team. Unfortunately, no update at this time but I'll be sure to get you added to the ticket so that you'll be informed when there's a change!
0
Hello,
Wanted to see if there is any update for indirect function ?
it is really useful to have this option in workiva0
Hi Samane!
Thanks for reaching out. At this time there's not any new significant updates regarding the INDIRECT function. This is something that is still planned and will move into 2025 planning efforts. I will get you added so you can stay apprised going forward but certainly give us a holler if you have any questions in the interim. Thanks much and have a great rest of your day!
0
Hi there, any updates on the timeline for this function? Thank you!
0
Hi!
Thanks for the note here. This feature add does remain planned and I've updated the status of this post to show as "Planned" too. Sorry for any confusion there.
I do not have a timeline as of yet. I should know more soon if it gets picked up for Q2 2025 and we'll certainly keep you apprised. Let me know if you have any additional questions for me in the meantime. Cheers!
0
The INDIRECT Function would be very helpful in Workiva spreadsheets!
... but just a few days left in Q2/2025 ;-)0
Hi Andre!
Thanks for keeping me honest and apologies for my delay. As we near the waning days of Q2 2025, I can report this did NOT get added to this quarter's items. It does remain planned for a future roadmap though and happy to add you to the list of requestors.
0
Also looking for INDIRECT formula functionality in spreadsheets, please can you add us to the list of requesters.
0
Hi,
please add us to the list as well.
0
Hi Katharina Wolters - I have you added to this request ⭐ I hope you have a great day!
0
Hi Brooke, is there any update on the INDIRECT function becoming available? I am a new requester. Thank you!
0
Hi Marina Grafel- Thanks for commenting & expressing your interest here for the INDIRECT function in Spreadsheets. I have added you to this request! Unfortunately, no updates yet, but we encourage anyone that would find this beneficial to please comment to get added! The more interest expressed on an idea, the higher chances that it will make it to the priority list! ✨
0
Could you please add me to this request as well?
0
Of course, Danilo Sato I have you added as well! ⭐ I hope you have a great day!
0
Brooke, I would also just like to mention that ideally the indirect formula, once published, can be used with sumifs in Wdesk. Thank you!
0
Thanks for including this information, Marina Grafel I will add that additional information to the ticket to show how truly beneficial this feature would be!
0
Hi all! Apologies for any confusion. As you might have noticed, Q2 of 2025 has come and gone and still no INDIRECT formula. Sorry for the delay in updates here. This does remain on the roadmap to be done but has been re-prioritized and shipped into 2026. I don't have any dates as of yet but we'll continue to track progress and requests here.
Thanks as always and holler if you need anything else. Cheers!
0
Also looking for the INDIRECT functionality, please add us to the list.
0
Mike Davis - We are also looking for this formula to be added. Looking forward to the update on when this will be available within Workiva.
Thanks!0
Comentarios
29 comentarios