Questions about Tables formulas

  • Folkhalsan
    Answered on October 28, 2020 05:32 AM

    1) Can I join two columns? If I have gathered i.e. first name and last name as separate columns and want to join them? Or if I want to join state and city?

    2) Is there a description of what formulas are available?

    3) the link to "create rollup" and "create lookup" does not seem to work.

  • Yvette_L
    Answered on October 28, 2020 07:33 AM

    Thank you for contacting us.


    You can concatenate 2 columns by using formulas under Advanced, please see screenshot below:

    1603883809 5f995321e4704 image (3) Screenshot 0


    There's currently no description just yet of what formulas are available, but you can certainly find them under Add > Formulas > Advanced Formulas > Functions:

    1603883882 5f99536ac70df asdkas;dlsdl Screenshot 1


    May I please ask you what are your requirements, so I can have a look and see if they work correctly?

    I hope this helps, looking forward to your reply, thank you!