Worksheet population with Formulas

MPC contact

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.

Thanks!

Paul Newcome

Insert the formulas into the first row and set them as column formulas. Any new form entries after this should automatically have the formulas in place.

Paul Newcome

Insert the formulas into the first row and set them as column formulas. Any new form entries after this should automatically have the formulas in place.

MPC contact

Works great!!! Thanks!

Paul Newcome

Happy to help. 👍️