Sign in to join the conversation:
Hi ,
How to use Index and Match function in SS.Please advise with an example
=INDEX([Range of data to be displayed from], MATCH([Identifier to look for], [Where to look for the identifier], [sort option]), [column index optional])
Use the first portion of the INDEX formula to set where the data you want displayed is to come from. Use the MATCH in the second part of the INDEX formula to designate what row to pull the data from. If you have a unique identifier for each row, use that, the set where to look for the unique identifier. The third portion of the INDEX formula is optional. Use this to specify which column to pull the data from if the first portion of the INDEX formula covers multiple columns.
Here is a link for further explanation...
https://community.smartsheet.com/discussion/auto-filling-cell-based-entry-another-cell
I am trying to calculate a formula that I can use in a dashboard graph. I need to show the following: status of a task (i.e. completed, in progress, etc) That it is US only (management responsibility) The end date is within the year 2026 This is what has been generated for me, through SS AI - COUNTIFS({My Sheet Name here…
am I close? not even with AI can I get it right. =COUNTIFS(OR({Milestones Status} = "Active", {Milestones Status} = "Pending"), {Milestones Market} = Item@row )
Hi Smartsheet Community, I’m looking for assistance with optimizing our workflow for our project intake process. Here’s our current setup: All project requests come in via a single intake form. They populate into our Prioritization Tracker Rows are triaged as Declined (move to Declined sheet), Backlog (move to Backlog…
