Calculated Field Formula with IF AND

Question

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 01:58

score 0 · Answer 1 · edited Apr 13 '17 at 12:41

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

edited Apr 13 '17 at 12:41

Community

answered Oct 28 '16 at 07:46

score 0 · Answer 2 · answered Oct 28 '16 at 08:50

0

Try

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

answered Oct 28 '16 at 08:50

Monica Jagani

2 Answers2