Comments
-
I'm starting to feel like this is some kind of bad joke... I really like SmartSheet for a lot of reasons but I grow ever frustrated with the weak and at times strangely arbitrary support of it's Function engine. You have and UPPER() and LOWER() why leave out PROPER()? I can appreciate that there are special considerations…
-
Sigh... Feels like every community post I stumble upon plays out just like this . . .
-
I know it's an old post, but figured I'd post for the next person searching. The formula below can calculate Median, BUT it will only work if the range is sorted first! Ascending or descending it doesn't matter; I've included a second more complex formula at the bottom that includes a rudimentary #SORTCHECK error if the…
-
isParent =IF(COUNT(CHILDREN()) > 0, 1, 0) isChild =IF(COUNT(ANCESTORS()) > 0, 1, 0) Generation =COUNT(ANCESTORS())