I have 2 list columns developed in my SharePoint form; country origin (CO) & country destination (CD) for the form requester to radio button (CO) and pull down and pick (CD). CD has two options: US & Canada, CO has 20 options. When the requester completes these fields in the soon to be form, I would like a calculated column to populate the known freight charge (rightnow I have it listed in a library). I was wondering how I can do this without incurring a nasty calculated column filled with limited Nested IF statements or a too complex workflow. Thank you for your help! I have access to SPD, and InfoPath, but after learning that is a bit easier not to begin with the infopath solution, I'm using SPD & The website for my pre-build.
Tell me more
×
SharePoint Stack Exchange is a question and answer site for
SharePoint enthusiasts. It's 100% free, no registration required.