Formula to filter?


Sheet w/ Source Data:

Goal: New sheet w/ just data for Fruit w/o using a Report and updates in real-time


  • Hollie Green
    Hollie Green ✭✭✭✭✭✭

    Few questions:

    Are you pulling in the count of each fruit? or just numbering them?

    Will the types of fruit change or always be consistent? and if they do change is it to often to update a row on your new sheet to match the types of fruit?

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!