You need to sign in to do that
Don't have an account?
![Brian Nolau Brian Nolau](https://dfc-org-production.my.site.com/img/userprofile/default_profile_45_v2.png)
Why can't I use a Lookup in a formula based on a picklist? I want to have two custom fields. I want the first custom field to be a Lookup but built with a formula based on another custom field with a picklist. I want the lookup to change basedon picklist
Why can't I use a Lookup in a formula based on a picklist? I want to have two custom fields. I want the first custom field to be a Lookup but built with a formula based on another custom field with a picklist. I want the lookup to change based on Picklist value. I obviously can't just manually use a Case Function with an IsPickVal function because IsPickVal returns a Boolean value that only works with Checkboxes which isn't compatible with a Case Function in which I want to return a Text Value.
Can we connect it with dynamic website? I'm working on Job posting project that hosted on WordPress. I want to use the saleforce service for my website (https://benchmarkrecruitment.ie).