Forum Discussion

lian96022's avatar
lian96022
Frequent Visitor
7 years ago
Solved

FORMAT and IF Statement

I have a Column that formats another Column with a date into "mmm-yyyy". However, if the cell is empty I would like it would place the text "Open" in the field. Currently I have Column = FORMAT(Sheet1[Closed],"mmm-yyyy")

 

Any suggestions...

Need Help
Tips and Tricks
  • JIGAR's avatar
    JIGAR
    7 years ago

    lian96022 

     

    You can create a new column using this formula.

     

    NewDateColumn = if(ISBLANK(Sheet2[ENDTIME]),"Open",FORMAT(Sheet2[ENDTIME],"mmm-yyyy"))
     
    Hope this helps !!
     
    Please mark it as accepted if the solution was appropriate.
     
    Thanks

2 Replies

  • JIGAR's avatar
    JIGAR
    Icon for Resolver IV rankResolver IV
    7 years ago

    lian96022 

     

    You can create a new column using this formula.

     

    NewDateColumn = if(ISBLANK(Sheet2[ENDTIME]),"Open",FORMAT(Sheet2[ENDTIME],"mmm-yyyy"))
     
    Hope this helps !!
     
    Please mark it as accepted if the solution was appropriate.
     
    Thanks