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.
Thanks!
Best Answer
-
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.
Answers
-
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.
-
Works great!!! Thanks!
-
Happy to help. 👍️
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives