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’m trying to set up an automation rule in Smartsheet where the “Status” column automatically changes to “In Progress” when the “% Complete” column is updated to a value between 1% and 99%. I noticed that there isn’t a “between” function available when setting conditions in the automation workflow. What is the correct way…
Hi all, I need support by set up of a formula. The case is: - If column 'Team' = Security AND column 'T-shirt size hours' = L = 2 days THAN column Days_Sec = 2 - If column 'Team' = Development AND column 'T-shirt size hours' = L = 2 days THAN column Days_DEV = 2 - If column 'Team' = Basis AND column 'T-shirt size hours' =…
Hi community experts, I'm trying to flag projects that are at risk. A project should be marked "At Risk" if the Status is not Complete, the Due Date is within the next 7 days, and the % Complete is less than 80%. Otherwise it should show On Track. What formula can do this?
