Hello everyone, Im currently using a very tedious process of finding the number that I need from this sheet. It is a pasted excel sheet into a Smartsheet. There are multiple repeating "CC Codes" that are only differentiated by the "111" number in the Primary Column. I need to find the value for each of these items on another sheet. On another sheet, the formula below is being used to return the number I need: INDEX({2022B}, 71, MONTH(TODAY())) * 1000.
What I want to do is find a formula that will find the number I need WITHOUT me having to change the row number for every value I need on the other sheet. Im open to slightly reconfiguring this sheet (like with Parent /Child ) but I dont want it to be tedious. Any thoughts or suggestions?
