I have a field containing some name and I want to make it in 2 categories like either assigned or not assigned. How I can achieve this.
This can be achieved using the calculated field where you can write the code like below along with ISNULL function as well.
IF ISNULL(name) THEN ‘Not Assigned’
ELSE ‘Assigned’
END