Show 1st, 2nd, 3rd often entry of a column



we use a sheet to collect incidents for the Facility Department (FM Tracker).

I want to show in a dashboard which are the incidents that occur most (rank 1, 2, 3)

In the sheet summary I already tried this:

=COUNTIFS(subject1:subject30); MAX(subject1:subject30); RYG:RYG; "rot") => #unparseable

Any ideas? ;-)🙄

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!