I am looking for a formula that I am stumped on:
I have a field with a single select that is called Campaigns.
Campaigns has three categories, A, B, C.
A, B, and C also represent tasks which is another field.
These tasks have 20 options that represent a lead time.
That lead time needs to be a workday add formula to a set lookup date that is driving these dates.
So I need the option for all noted: As an example I’ll use this, when you select A from campaigns that equals -30 days, allows you to select all tasks that each have a different lead time associated to then auto subtract workdays from the static look up date.
Does this make any sense, need multiple switch functions?