Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
I have a checkbox column "Inv 3rd Party Vendor." I am needing to index a master sheet with all of our property names, and look to see if the "inv 3rd party Vendor" box is checked in that sheet. If it is, I need it to check the box.
Is there data on each sheet that is unique to each row?
yes. each row has a property name that is unique to that row.
Ok. Try something like this...
=INDEX({Other Sheet Checkbox Column}, MATCH([Property Name Column]@row, {Other Sheet Property Name Column}, 0))
works great!!! Thanks!
SGF
Happy to help! 👍️
so invoice department added and additional column to index and match. They want to pull the "3rd Party Vendor" i copied the formula above and selected the column for the range, but its not quite returning the right info.
Here is the formula i am working with
=INDEX({CRS Vendor Setup Prop Name}, MATCH([Property Info]@row, {CRS Vendor Setup Vendor}))
But its returning the a value from the row above it. "Lumiere Chandler" instead of returning the value i want..."OPS"
Im missing something simple. Would you mind looking at it one more time?
Thanks
Try searching for an EXACT match with a zero at the end of your MATCH function....
=INDEX({CRS Vendor Setup Prop Name}, MATCH([Property Info]@row, {CRS Vendor Setup Vendor}, 0))
comes back with a "No Match"
Is that exact text within the range on the source sheet?
i need it return the value in the cell in the column "3rd Party Vendor Name" corresponding with "Madison at Round Grove" The value i need it to return is "OPS"
Am i using the wrong type of formula?
Yes. I understand what you need. I am just trying to help troubleshoot.
Try just the MATCH function.
=MATCH([Property Info]@row, {CRS Vendor Setup Vendor}, 0)
What happens?
still returns a NO MATCH...hmm
i figured it out.
=INDEX({CRS Vendor Setup Vendor Name}, MATCH([Property Info]@row, {CRS Vendor Setup Prop Name}, 0))
swapped the range values in the index and match.
Hi all, reaching out to see if of you have ideas; I'm hoping this makes sense: I'm having some trouble getting my formulas to pull data in correctly. I currently have a sheet (primary data) where I have data in rows where each row is a single project, with columns identifying persons, $ values, unique project identifier,…
Hello, I have a workflow where, when a team member checks a checkbox, Smartsheet automatically sends an email to themselves containing merge fields that are used as a customer email draft. The challenge is that this activity typically happens on a deadline day, and a team member may need to generate 30 or more of these…
I have a sheet with 5000 rows and 30 columns. with 4 columns of them are formular columns. How can i reach this limit for 25000000 formular cells reference? How can i enlarge this limit? I need those formular to link some data from another sheet as there is also Max cells limit for one sheet. How can I join those data…
