Looking for formula help
I am trying to write a formula that will subtract to date fields only when certain conditions are met. The fields for the conditions are checkbox fields. The formula field I started below is numeric....
Forum Discussion
Does this work?
If(
[Pharmacy] = true and [Fast Track] = false,
If(
IsNull([RX Ready Date]) or [RX Ready Date] < [Plan Set -Up All],
0,
ToDays([RX Ready Date] - [Plan Set -Up All])
),
0
)
Just containing it in another If statement.