The following formula used to work but stopped working recently. Anyone encountered the same issue and managed to resolve it?
=COUNTIFS([Assigned To]:[Assigned To], FIND("Name", @cell) > 0)
"Assigned To" is a contact column
Hi @Alan Phuan
Hope you are fine, i tested your formula and it's work perfectly, please try to create a new test sheet with the Assigned To column and try the formula if you face the same problem then Contact Support
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Hi @Bassam.M Khalil ,
Thanks for looking into this!
I created a new sheet and the formula does work. Looking into the issue again, the difference between the new sheet and existing sheet is that the contact column in the existing sheet is actually a vlookup formula that retrieves contacts from another sheet.
please try the same VLOOKUP formula in the new sheet and check are you facing the same problem you facing in the original sheet.
Looking to connect a dynamic view of HR dataset to a Power BI dashboard pulling information from multiple other sources. Appreciate any guidance, thanks
Hello! I copied a form I had made for a similar event I am working on now. I made minor adjustments to the form to match the needs of the event. I distributed the form for people to complete, so the form is active, but the data is not populating onto my Smartsheet. Please advise. I would prefer not to have people redo the…
Hello, when I modify a start date on a task I lose the predecessor links. Is there a method to modify task start dates without losing the links? THANKS.
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.