Automate Index / Match forumla - add an IF statement? or another Match??



I have a report that I will be data dumping into monthly (1st pic called "Jan GSS"). I created an Index/Match formula (in second pic) to pull those numbers over into my main sheet (GSS ITRec column):

=INDEX({Jan GSS ITR}, MATCH(Marsha@row, {Jan GSS MARSHA}, 0))

How can I make this formula better so that when I add the Feb and March and so on data to the sheet "Jan GSS" it will update the approprate month rows in main sheet for each property (pic 2)?

That way I can apply the formula to all the cells and don't have to update it monthly. Thank you!!

Best Answer


  • Ann Foley
    Ann Foley ✭✭✭✭

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!