Forum Discussion

Jliersenvlst's avatar
Jliersenvlst
Copper Contributor
Apr 19, 2022

Help with an excel formula

Hello,    I am writing a formula for table from column A to Column U.  (In the dutch version so I translated the formula from dutch to english).    The Formula is located in A4 Column A is called...
  • OliverScheurich's avatar
    Apr 19, 2022

    Jliersenvlst 

    =IF(T4=TRUE,"canceled",IF(R4=TRUE,"complete",IF(L4=TRUE,"process finished",IF(AND(J4<>"",J4<=TODAY()),"in process",IF(AND(J4<>"",J4>TODAY()),"assigned",IF(J4="","not assigned",""))))))

    You can try this formula which seems to work in my sheet if i correctly understand what you want to do. 

Resources