How can i pull the latest budget number from one sheet into another sheet automatically?

I have a sheet in which i track revisions, for each revision a new row is added. I'm trying to pull data from this revisions sheet to another sheet but i want to pull only 4 data fields that reflect the latest numbers for the last revision. Is there a formula i can use?

Answers

  • AravindGP
    AravindGP ✭✭✭✭✭

    Hi @olvin.vargas


    You can use an INDEX/MAX formula if you have an auto number column capturing the row# of the new row. If there are no other parameters to fetch the value, you can use the formula reference below.


    =INDEX({Column reference from sheet 1 which has the data you need}, MAX({Column reference from sheet 1 which has the auto number}


    You can replace the column reference after INDEX with column 2 to capture the second data field, and so on

    Thanks,

    Aravind

    Reach out for any help on licenses, configuration, or training

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!