Multiple Results Formula


Hello! everyone

I was wondering if someone could help me with a formula

We have an audit schedule based on 5 years and I currently have the "Count" essentially telling me how many times a topic was audited in the past 5 years.

What I would like to generate is - "in which years was the exact same topic audited?"

which would help me in building my yearly audit schedule :)

example -

Audit Topic - "Slip and Fall Program"

How many times in 5 years was this program audited - 4 times

---------------I have it figured out till here-----------------

Seeing if the below formula exists

"In which years was this topic Audited - 2020, 2018, 2016, 2021"

I would truly appreciate your help. thank you very much!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!