Newbie - Tracking Item location based on most current date

Options
Troy Bjelland
Troy Bjelland ✭✭
edited 11/22/21 in Formulas and Functions

I am fairly new to Smartsheet's and am struggling to figure out some of the formulas. I am with a volunteer fire department and we are using Smartsheet's to track our equipment and maintenance. I currently have a sheet that tracks when we fill our air cylinders and which station the cylinders are at. Each cylinder which has numerous entries and will change from station to station. I would like a separate sheet in card view for each station showing their bottle inventory. The problem is when we fill Cylinder 15 twice it shows two cylinder 15's at that station. I believe i need to use max(collect) but I don't understand how to make it work.

Any help would be much appreciated

.

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!