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...
Need Help
Vijay_A_Verma's avatar
Vijay_A_Verma
Icon for Most Valuable Professional rankMost Valuable Professional
4 years ago

Use this

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

    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
      4 years ago

      The above one is complete. 

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