Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Formula Help! New Column (If this is not blank, use this, else)

Hello!!

 

First time poster to this forum! HELPP.. I am struggling with this formula..  I have these three columns:

 

Scheduled End Date     Extended End Date      Actual End Date


It is like a funnel, so everyone has scheduled end date filled out, and then a good chunk have extended end date, and then only a few have actual end date -- 

I want to add a new column with an if statement, that if there is an actual end date, use that, if not then if there is a extended end date, use that date, else use schedule end date

 

Can someone help me with writing this formala exactly so I can copy paste? Thanks in advance!

 

Hannah

3 Replies

  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    Icon for Most Valuable Professional rankMost Valuable Professional

    Use this

    = [Actual End Date]??[Extended End Date]??[Scheduled End Date]
    • Anonymous's avatar
      Anonymous
      Not applicable

      thanks for your response! can you write it out completely? 

      • Vijay_A_Verma's avatar
        Vijay_A_Verma
        Icon for Most Valuable Professional rankMost Valuable Professional

        The above one is complete. 

        ?? is Coalesce operator like other operators such as or, and etc..