Classic file types are no longer available for use as of January 2021. You can transition your classic files or download a PDF. Learn More

Excel Indirect function

Request Demo

I 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.

11

Commenti

10 commenti

Data Voti
  • Isaac Oard

    Hi Bob Graham
    I will set up an idea ticket for you to track progress on this functionality.
    We appreciate your feedback!

    0
  • Samantha McDonald

    Hi, has this been developed yet? 

    1
  • Tyler Ferdinand

    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
  • Franz Weinberger

    We would also appreciate to get that function in Workiva! 

    1
  • Mike Bowden

    I wanted to inquire if the INDIRECT excel formula function has been added to Workiva?

    0
  • Isabel Messore

    Mike Bowden,

    The INDIRECT excel formula has not been added to Workiva yet. However, it is on our roadmap and planned for Q2!

    0
  • Jiang Chuanzhong

    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
  • Bob Graham

    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
  • Jason Kotze

    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
  • Isabel Messore

    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

Accedi per aggiungere un commento.