Formula, If/then statement??
We are using a form for meetings this fall and they will select the client on the form and then on the sheet whatever client they selected then the form will input the correct OneCode and VBC for that certain client - so that they don't have to go through the work of entering it on the form.
is that possible??
Answers
-
I had a similar challenge, where I ended up adding the field in the form with the appropriate code as the default value, and then hiding it; saving time and angst.
Hope this helps and that you have a great day,
Jason Albrecht MBA, MBus(AppFin), DipFinMgt
LinkedIn profile - Open to work
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.4K Get Help
- 446 Global Discussions
- 144 Industry Talk
- 478 Announcements
- 5K Ideas & Feature Requests
- 85 Brandfolder
- 151 Just for fun
- 72 Community Job Board
- 490 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 302 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!