Skip to main content
SharePoint

Return to Question

added 6 characters in body; edited tags
Source Link
Ganesh Sanap - MVP
Ganesh Sanap - MVP
  • 46.4k
  • 22
  • 31
  • 63

I am trying to implement the following code in a calculated column named [Valid] in a document library in modern SharePoint online.

=IF([Valid Until]-TODAY()>=0,"Valid","Expired")

=IF([Valid Until]-TODAY()>=0,"Valid","Expired")

It works fine as long as a document file is uploaded to the library. However, when I upload a folder containing different documents, this does not work and the value displayed in the [Valid] column for the folder is always "Expired". This could be because when I upload a folder the [Valid Until] column does not take any value as input because it is not needed as opposed to a file. How can I solve this issue and display nothing in the [Valid] column when I am uploading a folder?

I am trying to implement the following code in a calculated column named [Valid] in a document library in modern SharePoint online.

=IF([Valid Until]-TODAY()>=0,"Valid","Expired")

It works fine as long as a document file is uploaded to the library. However, when I upload a folder containing different documents, this does not work and the value displayed in the [Valid] column for the folder is always "Expired". This could be because when I upload a folder the [Valid Until] column does not take any value as input because it is not needed as opposed to a file. How can I solve this issue and display nothing in the [Valid] column when I am uploading a folder?

I am trying to implement the following code in a calculated column named [Valid] in a document library in modern SharePoint online.

=IF([Valid Until]-TODAY()>=0,"Valid","Expired")

It works fine as long as a document file is uploaded to the library. However, when I upload a folder containing different documents, this does not work and the value displayed in the [Valid] column for the folder is always "Expired". This could be because when I upload a folder the [Valid Until] column does not take any value as input because it is not needed as opposed to a file. How can I solve this issue and display nothing in the [Valid] column when I am uploading a folder?

Add tag "sharepoint-online"
Link
Michael Han
Michael Han
  • 5.2k
  • 1
  • 8
  • 12
Source Link
Ray_0052
Ray_0052
  • 1

How to get a particular value in the calculated column

I am trying to implement the following code in a calculated column named [Valid] in a document library in modern SharePoint online.

=IF([Valid Until]-TODAY()>=0,"Valid","Expired")

It works fine as long as a document file is uploaded to the library. However, when I upload a folder containing different documents, this does not work and the value displayed in the [Valid] column for the folder is always "Expired". This could be because when I upload a folder the [Valid Until] column does not take any value as input because it is not needed as opposed to a file. How can I solve this issue and display nothing in the [Valid] column when I am uploading a folder?