Skip to content

Instantly share code, notes, and snippets.

@dansayo

dansayo/code.bas

Created November 8, 2019 07:58
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save dansayo/70048e3bcc537f6cca9a3a372858b2eb to your computer and use it in GitHub Desktop.
Save dansayo/70048e3bcc537f6cca9a3a372858b2eb to your computer and use it in GitHub Desktop.
Download ZIP
Smartsheet formulas to get unique values
Raw
code.bas
Use case on say 6 columns having email addresses, and you want to get only the unique values.
Copy-paste the formulas in column pairs [iterate, scrubbedapp]
iterate2 column formula:
=SUBSTITUTE([iterate1]2, "#" + [ScrubbedApp1]2, "")
ScrubbedApp2 column formula:
=IF(NOT(ISBLANK([iterate2]1)),
MID([iterate2]1, 2,
IF(FIND("#", [iterate2]1, 2) > 0,
FIND("#", [iterate2]1, 2) - 2,
LEN([iterate2]1))), "")
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment