Need help with a formula for my asset report


I'd like to know what formula would give me the desired output from data within my asset inventory sheet. I'd like this output to be populated in my report. See example



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!