Forum Discussion
sccoleman1189
6 years agoHelper I
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!
- 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!
parry2k
6 years agoSuper User
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!
sccoleman1189
6 years agoHelper I
Thank you! I knew it was simple. I was having a huge brain fart!