Forum Discussion

jrpoli2000's avatar
jrpoli2000
Frequent Visitor
8 years ago
Solved

Need Help with SWITCH or IF function

Hi!   Im trying to create a calculated column to determine the status using 2 columns (initial and final review) as reference.   INITIAL REVIEW FINAL REVIEW STATUS COMPLETED   PENDING F...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    jrpoli2000- Perhaps try this:

     

    STATUS = 
SWITCH(
    TRUE(),
    ISBLANK([INITIAL REVIEW]) && ISBLANK([FINAL REVIEW]),
        "PENDING INITIAL AND FINAL REVIEW",
    [INITIAL Review]="COMPLETED" && [FINAL REVIEW]="COMPLETED",
        "COMPLETED",
    "PENDING INITIAL REVIEW"
)
Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

jrpoli2000- Perhaps try this:

 

STATUS = 
SWITCH(
    TRUE(),
    ISBLANK([INITIAL REVIEW]) && ISBLANK([FINAL REVIEW]),
        "PENDING INITIAL AND FINAL REVIEW",
    [INITIAL Review]="COMPLETED" && [FINAL REVIEW]="COMPLETED",
        "COMPLETED",
    "PENDING INITIAL REVIEW"
)
jrpoli2000's avatar
jrpoli2000
Frequent Visitor
8 years ago

Thanks a lot!!! also used ISTEXT because the entry sometimes for both Initial and Final Review columns will not be always COMPLETED.

 

Thanks again!