This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I'm trying to link to an excel input file in the workflow that not only has a changing file name based on the month pulled, but the tab I need to reference also has a changing name based on the month (for example, file name = PReq September 2019.xlsx, table/tab name = Sept Preq). I've used a wildcard in the file path to take care of the changing file name issue, but I still haven't found a solve to reference the changing table/tab name. Is there a way to easily do this? I've looked into the Dynamic Input tool but am not quite sure how/if this would work in this instance. To add additional info, the table/tab I would need to reference would always include the word "PReq".
Thanks @benakesh , the first solution worked great, I just added a filter tool between the formula tool and the dynamic input to read only sheet names that contain "PReq" and it was just what I needed.