HELP! Handling Cascaded Lookups with Workflow / Calculated Fields

Mar 5, 2012 at 8:12 AM
Edited Mar 5, 2012 at 9:40 AM


I managed to get it to work on my SharePoint Site.

Now I am trying to manage a connection between the Lookups and a Workflow or a Calculated field.

I created a Calculated Field, wich gets the difference between two dates. Now a Workflow should do the following:

If the difference between the two dates is bigger then 90 Days, set the Cascaded Lookup Field called "Timespan" to "plus 3 Month" else set it to "minus 3 Months".

Now my Workflow isnt able to "recognize" the Cascaded Lookup "DropDown" as a proper DropDown wich makes it very hard to manage it.

Or is there a way using Calculated fields? Like setting a Dropdown with two entrys (e.g. 1 and 2) and if the difference of the datefield is bigger/ smaller then 3 Month it sets the value of the dropdown to 1 or 2 and after that, a calculated Field with an "If... Else... Then..." function will set the Cascaded Lookup Field to +3 or -3?


Thank you in advance for your help