If/Then Date Formula (Multi Conditions)
I'm trying to create target serviceability dates, with multiple conditions, and it's seeming to only want to acknowledge the first portion of the logic. I am using relationship date fields, maybe that...
Forum Discussion
I think you should do it like in excel, when the first criteria is true you should evaluate the second criteria, nested IFs.
Marcelo Benavides Torres
marbentor @ gmail.com
In Quickbase you generally do not use nested IFs/
just one IF
IF(
[Hut - DIA Due Date] > [Splicing Target Completion Date]
and
[Hut - DIA Received/Complete]) < [Splicing Target Completion Date]),
[Splicing Target Completion Date],
[Hut - DIA Due Date] > [Splicing Target Completion Date])
and IsNull([Hut - DIA Received/Complete]), [Hut - DIA Due Date],
[Splicing Target Completion Date])
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
just one IF
IF(
[Hut - DIA Due Date] > [Splicing Target Completion Date]
and
[Hut - DIA Received/Complete]) < [Splicing Target Completion Date]),
[Splicing Target Completion Date],
[Hut - DIA Due Date] > [Splicing Target Completion Date])
and IsNull([Hut - DIA Received/Complete]), [Hut - DIA Due Date],
[Splicing Target Completion Date])
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
