Formula - Row Summary

ccisneros
ccisneros ✭✭
edited 08/09/23 in Formulas and Functions

I have 2 different sheets going into one report so I can track benefits/staff adjustment changes through the year. When it comes to renewal time, I would like to be able to pull down the most current information into one row. Is that possible?

Answers

  • Samuel Mueller
    Samuel Mueller Overachievers

    @ccisneros Reports with difference sources will always appear on separate lines. There is no way to match up to one row.

    You would need a 'matrix' sheet or just a third sheet with cross sheet references to both of your sources. Then you would need a unique identifier or something unique and use an index match formula.

    If I did not answer your question, please include some more detail on your situation and I will try to help further.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!