Forum Discussion

EloiseJane's avatar
EloiseJane
Frequent Visitor
4 years ago
Solved

Multiple IFs

Hi all   I am trying to workout if something is within timeline, but i need it to check if a field has a date first then if so work out X if not check this field isnt blank and work out Y   this ...
Need Help
  • Tahreem24's avatar
    Tahreem24
    4 years ago

    EloiseJane Try out with Switch:

    Test PPA =SWITCH(TRUE(),
                                  DATEDECISS>DATE8WEEK,"Exceeds",
                                  DATEDECISS=BLANK(),BLANK(),
                                  DATEDECISS>DATE8WEEK,"Exceeds", "Within")

     

Tahreem24's avatar
Tahreem24
Super User
4 years ago

EloiseJane Try out with Switch:

Test PPA =SWITCH(TRUE(),
                              DATEDECISS>DATE8WEEK,"Exceeds",
                              DATEDECISS=BLANK(),BLANK(),
                              DATEDECISS>DATE8WEEK,"Exceeds", "Within")

 

  • EloiseJane's avatar
    EloiseJane
    Frequent Visitor
    4 years ago

    thank you this worked ğŸ˜€