I have two smartsheets. One contains my budget and one contains budget vs actual. Currently, Im using an index function to find the budget for the month of each cost account BUT every month I have to go update the column index in the function so that it updates. What I'd like to do is make a reference where I can just put in, for instance, 2, and it would move to the next column. Is this even possible?
Help Article Resources
Check out the Formula Handbook template!