Forum Discussion

robmatey's avatar
robmatey
Copper Contributor
May 23, 2025

Need help with calculated column

I have a SharePoint list with a calculated column. I have the formula below and it works perfectly to display the status based on validity dates. However, now I only want to display the result if another column [Label Type] equals "Test". If it doesn't, the result would be blank. How would I write that?

=IF(ISBLANK([Valid From]),"In Progress",IF([Valid To]<TODAY(),"Obsolete",IF([Valid To]>TODAY(),"Ready")))

 

 

Lists
Microsoft365
SharePoint Online

1 Reply

  • michalkornet's avatar
    michalkornet
    Iron Contributor
    Jun 30, 2025

    Hi robmatey​ ,  try something like this. In bold, I have added a new part of the  code ->

     

    =IF([Label Type] = "Test",IF(ISBLANK([Valid From]),"In Progress",IF([Valid To]<TODAY(),"Obsolete",IF([Valid To]>TODAY(),"Ready"))) ,"")

Resources