Formula, If/then statement??

crystal.schroeder
ββββ
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
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!