Questions about Tables formulas

  • Folkhalsan
    Asked on October 28, 2020 at 5: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
    Replied on October 28, 2020 at 7:33 AM

    Thank you for contacting us.

    1.

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

    1603883809 5f995321e4704 image (3) Screenshot 10


    2.

    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 21

    3.

    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!