I have a list view I'm trying to set up using a calculated column to return yes or no by calculating dates. The user enters a date in a form, and the column should reference the created date, calculate and return a yes or no. When I create a list view filtering out yes or no I get no results, however the column correctly populates the yes/no result on the list.

AND([Current Scheduled Date]>[Created]+1,[Type of Job]="TC"),"Yes"
    ,IF(AND([Current Scheduled Date]>[Created]+5,[Type of Job]="PW"),"Yes","No"))

Any help would be greatly appreciated.

Thank you!

1 Answer 1


Fixed - I was able to resolve this by changing the yes/no choice result to single line of text containing "Yes" or "No" in the edit column section, and setting the filters to apply if the column contained "Yes".

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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