I would like to create a calculated field that outputs "Yes" or "No" if an item in my SharePoint list has been

  1. created in the last 7 days,
  2. closed in the last 7 days (field in status column), or 3) displays "Open" or "In-Progress" under the status column.

It is not supported by Microsoft to create calculated columns that references the system date (TODAY).

You should look for alternative. My recommendation is to use JSLink. It can be useful for painting with a color for example. Or something related to what you need. I leave you a good place to start with jsLink.

Client-side rendering (JS Link) code samples

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.