Sign in to join the conversation:
i've used this in the past but now all queries come back blank
It works for me. Do you have variations of the same name (ex. FirstName LastName, FirstName.LastName, firstname.lastname@domain.com) where you are looking for one variation, but other variations of the same "assigned to" are actually populating your field?
If this is what you are referring to, it's a known issue.
https://community.smartsheet.com/discussion/filter-contact-not-working
I use "assigned to" "is one of" and just include the other variations of the name. This can also help to filter multiple contacts.
I believe the issue is that the criteria 'is one of' doesn't work across all sheets; according to Support, they are "still investigating a bug causing this behavior."
Hey, I am using the below formula→ =INDEX({Source_Sheet_Entire_Table}, MATCH([Unique ID]@row , {Source_Sheet_ID_Column}, 0), 1) Although the answer should be "Project details" mentioned in Column 1, it says #No Match. What am I doing wrong?
How can I delete old sheets I no longer use from my account?
I'm trying to display a task progress chart showing "complete", "late", and "not complete" in my dashboard and for some reason the chart will display as a column chart but it won't display as a donut chart even though I'm referencing the same report. I'd prefer to display as a donut chart as I think it looks better and is…
