Forum Discussion
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 ano...
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"))) ,"")