JOIN COLLECT two variables

gwson
gwson ✭✭✭✭✭
edited 06/10/20 in Formulas and Functions

I am trying to find a way to collect two different variables from two different ranges {courseyear} and {regstatus}, then join them together to determine the year and registration status in a single cell:

Here is what I would like:

=JOIN(COLLECT({courseyear}, {id}, $ID@row, ({regstatus}, {id}, $ID@row)), "-")

Output: 2020-R, 2021-R,2022-W

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!