Compensation Plan Worksheet with notes
I have created a report to pull compensation worksheet with notes. I am facing the following issues:
1) It only picks up employees with Notes. I need to pull the = exhaustive list with or without notes. When I filter with Notes = 0 , there are no rows. While on UI we have 22 people without notes
2) I have used the Data format as HTML. When I export each comment comes as separate rows. I have used repeat column on each of the column. That way I am not able to manually copy the comments as well.
Any hints how I resolve these issues?