How to Return Values from another sheet in deliminated format?

Hi Smartsheet community,

I want to be able to return values in Sheet 2 in deliminated format. I have attached the diagram for reference.

Please suggest the appropriate function or way to get the output?

Thanks,

Binika

Answers

  • Hi @Binika Chunara

    You can use a JOIN(COLLECT formula to collect together the different values in one cell. However the tricky part will be defining the Names that you're looking to bring the Cost back from. Do you have a way of identifying the "group" of Names in both sheets?

    For example, if you have an identifier that tells you that you want A, B, C, and D together, you can use this as criteria in your COLLECT function.

    In my example, I have a group identifier saying "Group 1" or "Group 2" to show what letters to collect in the "Name" of Sheet 2, and then what Cost to collect in the corresponding cell. Does that make sense?


    To help further, it would be helpful to see screen captures of your actual data, but please block out sensitive information.

    Thanks!

    Genevieve

    Need more help? 👀 | Help and Learning Center

    こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions

  • Thanks for your help Genevieve P. This helps :)

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!