Sign in to join the conversation:
How can I extract a list of unique values from a list on another sheet? I tried doing this as if in Excel but it isn't working quite right.
Thank You! This worked for me. I added a column with sequential numbers (1 thru 50) and referenced that column in the formula to get all the second, third, fourth, etc unique names.
@john I That's typically what I do as well, but you indicated the desire to avoid helper columns which is why I just went with the hard coded number that gets manually changed for you.
I"ve been thinking through this for days trying matches and countifs but running into the dreaded cell formula limit. This INDEX(DISTINCT) combination was exactly what I was looking for.
Well done!
Hi there! Our Account Manager today informed us that users would need to be paid members to receive and complete Update Requests going forward. I can't imagine that Form users would need to be members, but I don't know how that differs from Update Requests, since neither requires access to the underlying sheet. Is it…
This discussion was created from comments split from: Generate documents from row data.
Error occurs when opening Vault Apps in Smartsheet WorkApps. The app fails to load and displays an error message despite logging out and back in. Issue has been ongoing since last Monday
