Renumber sheet based on associated levels of views


#1

Hi,

Im trying to rename a set of sheets based on associated levels of views placed on that sheet.

This is proving difficult, as some sheets contain multiple views. if these views are based on different levels, Id like the sheet to be a “ZZ”. If it contains one view, or multiple views of the same level, it needs to be named after the appropriate level.

Im really struggling to write a logic test capable of this. has anyone completed a similar task?

Ben.


#2

Something like this:

vals = List.UniqueItems;
cnts = List.Count(vals);
cnts >1? ZZ:vals;