Worksheet population with Formulas


I have a spreadsheet populated by a form where one field needs to be populated using a JOIN of multiple fields from the spreadsheet which are populated using from entry and another needs to be populated by a VLOOKUP. I've tried assigning the formulas to the blank rows ahead of time and using the Change Cell Value workflow to assign the formula to the fields. Neither works. Is there another option? I'm a newbie to SmartSheet.


Best Answer