Teams need to compare the built-in Assigned to field with one or more custom Users fields directly inside list report calculation columns.
Today there is no supported native way to create a calculated column that reliably identifies a mismatch between Assigned to and a custom Users field.
Requested support:
Allow custom Users fields to be referenced in list report calculation columns
Support direct comparisons between Assigned to and custom Users fields
Support practical mismatch checks such as equality, inequality, blank checks, and simple conditional logic
Example use cases:
Flag features where Assigned to does not match the responsible owner stored in a custom Users field
Audit records where Assigned to is blank but a custom owner field is populated
Create report views and dashboard filters based on mismatch status without exporting to CSV
Current workaround:
Export list reports to CSV, compare values in Excel or Google Sheets, and re-import updates
Use automation to keep Assigned to synced from a source-of-truth user field where possible