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
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 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!