Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Multiple, comma separated values in one cell
I'd like to create a report which returns all rows that have a certain value in column 'Donors' - i.e. we have activities that are funded by one or multiple donors, and I'd like to return all activities that are funded by Donor X.
Conference one - donor x, y, z
Conference two - donor y, z
Three - donor x
And the report should only report lines with X.
A simple column with text/number will treat comma separated values as separate values, and the report won't allow me to say 'field donor contains X'.
Anyone know how to do that? Workaround? I see that for now, mulitple-assigned contact lists (for which this would be very useful too, without resource-utilisation even) is still in construction if at all