AppSheet, Google
Jump to navigation
Jump to search
Check if input is greater than 2 char and contains a space
AND((LEN([_THIS]) > 2), CONTAINS([_THIS], " "))
Or, And, In, Not, If
OR(USERSETTINGS("Singer")="Anita L", USERSETTINGS("Singer")="Anita L.")
AND(ISBLANK(USERSETTINGS("Singer")), IN("Karaoke",ActiveSession[Session]))
IN("Karaoke",ActiveSession[Session])
NOT(USERSETTINGS("Singer")="R Bas")
IF(IN(Context("View"),List("JOIN QUEUE")),"Submit Song","Save")
upper(CONCATENATE("#",SUBSTITUTE(upper([Name]), " ", "")))