Attempting to get a Calculated Column to output Yes/No (Formula)

Question

I am trying to make a calculated column produce a Yes/No when:

IF([Reminder Date]= [Today], “Yes”)

and

IF([Reminder Date] does not equal [Today], “No”)

What is the correct formula?

Answer 1

The IF has 3 arguments, so:

IF(A, B, C)

• where A is a boolean expression
• B is what's returned if A is true and
• C is what's returned if A is false

So if you want something like:

=IF([Reminder Date]=[Today], "Yes", "No")

Answer 2

Basic syntax for IF statement in calculated formula is:

IF(logical_test,value_if_true,value_if_false)

So, try to write down your formula in above format.

Note:

1. Sometimes comma(,) does not work in formula (I am not sure but it is based on something language on your site). So in that case use semicolon(;) instead of comma(,).

   For detailed information and references check my answer given in below link:

   IF statement with text field isn't possible?

2. Sometimes, The [Today] is not supported in the Calculated Column. Check below work arounds before using Today in your formula.

   • How do I make a calculated field with a filter in SharePoint 2010?
   • How to use Today and Me in Calculated column