Index Question


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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!