1

Trying to get this calculated column value to work and having trouble with the syntax:

=IF(AND([Due Date]<=[Today],ISBLANK([Release Date])),"Yes", "No")

Pretty much if "Due Date" is less than or equal today and "Release Date" is blank then show "Yes" otherwise "No".

  • What is your question? Have you entered the formula? Have you seen the error message that calculated columns cannot contain volatile functions like Today? What are you asking us to do? – teylyn Oct 28 '16 at 1:58
0

Your Calculated Column syntax is correct.

and could be shortened to:

=AND( [Due Date]<=[Today] , ISBLANK([Release Date]) )

BUT

[Today] does not behave like it does in Excel;
it will always be the date the Item was last touched

How to use Today and Me in Calculated column

| improve this answer | |
0

Try

=AND( [Due Date]<=[Today()] , ISBLANK([Release Date]) )
| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.