Newbie - Tracking Item location based on most current date

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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!