Calculated coulmn : Check if a column value or a part of it matches specific text - Microsoft Community Hub
![Using a SharePoint Calculated Column can result in an "Input string was not in a correct format" error | Community Using a SharePoint Calculated Column can result in an "Input string was not in a correct format" error | Community](https://cdn-cms.k2.com/kbs/img/155/calcsettings.png)
Using a SharePoint Calculated Column can result in an "Input string was not in a correct format" error | Community
![Mike Smith's Tech Training Notes SharePoint, PowerShell and .Net!: SharePoint: Creating Calculated Column Formulas the Easy Way Using Excel Mike Smith's Tech Training Notes SharePoint, PowerShell and .Net!: SharePoint: Creating Calculated Column Formulas the Easy Way Using Excel](https://lh4.ggpht.com/_bQ5Jm4PvS5Q/TFy_VUcK0VI/AAAAAAAAAd4/GMBbtCiWqHs/image_thumb%5B23%5D.png?imgmax=800)
Mike Smith's Tech Training Notes SharePoint, PowerShell and .Net!: SharePoint: Creating Calculated Column Formulas the Easy Way Using Excel
![ISBLANK() or LEN() not working while checking Calculated Column which returns Date by formula for SharePoint List - Stack Overflow ISBLANK() or LEN() not working while checking Calculated Column which returns Date by formula for SharePoint List - Stack Overflow](https://i.stack.imgur.com/HVrwA.png)