Forum Discussion
SharePoint Calculated Column to compare two Person fields
Is it possible to create a calculated column to compare Person Field A with Person Field B?
AdminAy Those Person fields are not available to choose from to do the comparison and if I manually add them, it gives me this error, "One or more column references are not allowed, because the columns are defined as a data type that is not supported in formulas." Seems like I would need to copy those Person fields into a single line column and then compare.
Ok, but use a SharePoint workflow or a Power Automate flow to automatically copy the values from the Person fields to the corresponding single line of text columns whenever changes occur.
This will ensure that the text columns stay up-to-date with the Person field values.
Once the values are copied, then you can apply the formular
This will ensure that the text columns stay up-to-date with the Person field values.
Once the values are copied, then you can apply the formular