Forum Discussion
IF formula error message "The formula contains a syntax error."
The column Monitorar is a date/time field, but the calculated column is a number field and should accept either 0 or 1. I wasn't sure that a date could equal 0, but I tested this and it works fine:
=IF([Due Date]=0,0,1)So today I learned a empty date field equals 0. Good stuff!
valderes-squadraFrom the screenshot you attached, it looks like [Monitorar] column is of type "Date" and not "Number". Is this causing the problem here?
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
The column Monitorar is a date/time field, but the calculated column is a number field and should accept either 0 or 1. I wasn't sure that a date could equal 0, but I tested this and it works fine:
=IF([Due Date]=0,0,1)
So today I learned a empty date field equals 0. Good stuff!
Thanks to all for your replies. Obviouslý I forgot that numbers don't need quotes. PamDeGraffenreid, your solution worked.
