Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAQuestion asked was for macro, Solution uploaded was directly providing the macro output, so wasnt able to figure out how.
But tried providing output using the below formula
IF [Level0]=33333 OR [Level1]=33333 OR [Level2]=33333 OR [Level3]=33333
THEN 33333
ELSE "NA"
ENDIF
Fun little challenge. I decided to create a NAME/VALUE list for the interface. I challenged myself to make the rest as dynamic as possible to ensure we could also add multiple additional Levels without the need for changes in the flow.
Didn't bother to replace the Null values as wasn't sure about the final CEO level.