I have created a formula field on my Project Status record to concatenate Project record id (totext version of it) and a date field on the project status record (child of project). I would like to make this unique so the system would prevent the user from creating multiple statuses on the same date for a project. When I try to enforce uniqueness on this field I get the following error message:
Here is the formula:
ToText([Project - Record ID#]) &
Mid(ToText([Status Week Of]),7,4) & Mid(ToText([Status Week Of]),1,2)
& Mid(ToText([Status Week Of]),4,2)
Here is the error message when I try to enforce uniqueness:
“This formula is incompatible with this field being marked unique. Please change the formula or uncheck the unique checkbox.”
How can we meet the requirement underlined above? Let me know if you need further clarity.