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."
Have any of you created a Smartsheet that would show the savings for a project by the month? In other words, if I saved $1200 annually and the project ended in say March, then the savings would go $120 per month, Mar 2025-Feb 2026. I have done it on Excel sheets manually, but I think there should be a way to do it with…
Hello team! Hope you all are having a wonderful holiday season. I am trying to set up an automation that will send an email reminder one time when Next Update Date = 60 days, then another automation at 30d, etc. The key is I only want it to send the reminder one time when Next Update threshold is reached. Is this possible?…
Has anyone found a workaround for sharing Smartsheet reports externally without giving access to internal data? I currently have to download the data and transfer it onto excel to create a pivot table for our client and I want to find an easier way to do so. I also already create a dashboard for our client, but I wanted…
