Hi! When I pull Most Recent Gift date into my Prospecting widget the result is 1/1/00 for constituents who have never donated. Is there any way to remove these values from the display? I am also trying to sort on Constituent Sort Name with no luck!
I'm not sure you can just have blank cells, hence why the default to 1/1/00. And while you could filter that date out, I doubt you want to lose the patrons the information is attached to.
You're right, you can't have blank cells. I do not want to filter out the patrons so I guess I'll have to deal with it!
This is extra work (and you may already be aware) but you can save the pivot table into an excel sheet and do a find and replace of "1/1/00", setting it to replace that with nothing (or with "N/A" if you'd rather). Again, extra work but an option.