Best Of
#NO MATCH in Index/Match for Grandparent Row
I have a typical hierarchical project plan sheet with the project name on Row 1 and every other row indented under it to various levels.
The Setup:
Column: "TaskCounter". An Auto-number column with no Prefixes or Suffixes.
Column: "TaskID". Column Formula: =MATCH(TaskCounter@row, TaskCounter:TaskCounter, 0)
Column: "Level". Column Formula: =COUNT(ANCESTORS())
Column: "WS Name Row". Column Formula: =MAX(COLLECT(TaskID:TaskID, TaskID:TaskID, @cell < TaskID@row, Level:Level, 3))
Column: "Workstream Name". Column Formula: =IF(Level@row = 3, [Task Name]@row, INDEX([Task Name]:[Task Name], MATCH([WS Name Row]@row, TaskID:TaskID, 0)))
The problem is in the "Workstream Name" column. It displays #NO MATCH for any row with a Level greater than 3. Those are the rows I actually need.
The Problem: Rows 360, 366 and 367 should display "WS7: Hardware" in the "Workstream Name."
There is a clear match on the value of 359, but the Index/Match formula returns NO MATCH. Why?
I realize this is a complex one -- any help is appreciated.
Manuel W.
Re: Lock single cell
I want to be able to lock a cell so it can't be edited when specific criteria is met. Example, when the status has been marked as Completed, the completed date cell will then be updated with the current date and then cell should be locked so that it can only be edited by the admin. Currently, we only have the ability to lock an entire row.
usercnv25
Help Article updates October 2025
Hello Community,
We’ve published new videos on these topics:
- How to use columns in Insert, delete, or rename columns
- How to use timeline view in Introduction to timeline view
- Widget types in dashboards in Widgets for Smartsheet dashboards
To view the entire catalog of help articles, visit the Help and Learning Center.
Were the articles helpful?
Let us know by providing feedback for each article.
Trelawney
Re: In Calendar and Card Edit View, Hide Data in Hidden Columns
Please make this available in Card View as well! The Board view doesn't function as well as the Card View for our purposes.
Available Now! · Last Updated 07/26/24
Good news - in the new Board view, the details panel does not show any data in hidden columns. Supporting configuration of which fields appear in the details panel is a further enhancement that our product team is researching for new views.
BarbaraHanville
Re: Post Collection Release - Still Need Folder-Level Permissions
Another voice to add that we REALLY need folder level permissions. The extra work and organizational maneuvering required because this is not an option is really frustrating.
Heather Hartnell
Re: Date formula returning "#INVALID DATA TYPE"
The MID function converts everything to text. Try wrapping each of those in a VALUE function.
=VALUE(MID(...................))
Paul Newcome
Plan level visibility in Workspaces now available
October 15, 2025
Users will now know which plan their workspaces belong to with a new plan identification chip located at the top of the Workspace panel. Learn More
Environment Availability: Commercial US, Commercial EU, Commercial AU
Plan Availability: All
Subscription Model Availability: Legacy and USM
Stay informed by Subscribing to receive product release updates for curated news of recently released product capabilities and enhancements for the platform of your choosing, delivered to your inbox. As new releases occur, you will receive a weekly email with news of what's released every Tuesday.
Haley Patrone
Re: Smartsheet as a data source for an AI Agent
Thank you for pointing me in the right direction. 🙂
Steve Cohen
Learn how McLaren Formula 1 Team finds its edge with Smartsheet ✨ Share your story and enter to win
Smartsheet Community members from around the world are using Smartsheet Intelligent Work Management in ways that allow them to reduce friction and scale at speed.
For the McLaren Formula 1 team, this means less time planning and more time pushing limits.
“With Smartsheet, we’ve cut planning and preparation time for wind tunnel projects by 70%. What used to slow us down now flow seamlessly, freeing our team to focus on performance where it counts most.” - Spencer Ford, Director, Machining and Additive Manufacturing at McLaren Formula 1 Team
McLaren is just one of many customers achieving amazing results with Smartsheet—and we know you have a story, too. Whether you use Smartsheet AI tools to save time by harnessing your sheet data to craft compelling ad copy, analyze sentiment, translate text, summarize task status or more –share in the comments below, and you’ll be entered to win Smartsheet swag.
Arsineh