How do I show data from 2 rows in the same sheet returning the same information

Example all of this information is contained in the same sheet

Role 1 - staff 1 is an Administrator

Role 2 - staff 2 is a Scheduler

I want to ensure for each role that I am counting both rows (Role 1 and Role 2)

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!