Hi, I would like to create a checkbox formula to identify project category for miscellaneous projects to set value to TRUE if Project name field contains Misc% in the name.
I used this – in the checkbox formula field
If(Contains([Project #],"MISC"),true,false) – but the checkbox does not work, it is disabled.
Could someone please help? Is this formula check box will automatically set each new project that contains MISC% in the name as YES ?
Thank you so much