Forum Discussion

sccoleman1189's avatar
6 years ago
Solved

Create new column based on conditions

I need help with something im sure is very simple.   I have two columns: create date and appointment date   What I want: if appointment dat =create date +1 then 1, if not, 0   Thanks!
  • parry2k's avatar
    6 years ago

    sccoleman1189 add a new column with the following expression:

     

    Flag = IF ( Table[Appt Date] = Table[Create Date] + 1, 1, 0 )

     

    I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!