Forum Discussion

SarahGriffin's avatar
SarahGriffin
Qrew Member
3 years ago

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...
MarceloBenavide's avatar
MarceloBenavide
Qrew Cadet
3 years ago
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


  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    3 years ago
    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
    ------------------------------