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:
Hi,
I am looking for a formula that can return the first, second, third ... value in the table.
Using Vlookup will only return the first match
Any suggestions!!
Thanks
Fadi
It depends on how you are setting your criteria. Can you give more details and maybe include a screenshot after manually entering the data in the way that you would like it to appear?
Hi, I am after this function at the moment, but I don't know how to do it. I have a checkbox column, that when it is checked in one sheet I would like it to be pulled through to another. I have done a vlookup to do this but it on but it only returns the top value, is there a way to pull out all of the ticked check boxes in the sheet (without a report)?
That's going to depend on the details and how everything is set up. Are you able to provide some screenshots?
This is the sheet I want to take the lines from, so on the left are the check boxes and I need to pull them all into one sheet (not a report)? Is there a way to do this please?
Hi Claire,
Can you describe your process in more detail? What do you want to do with the information?
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
I have one sheet that people fill in with requests from clients. Sometimes some of these requests need to be repeated and we want to track these lines in one place (other than the master sheet) and then calculate our metrics from this, this is why I would like it in a sheet rather than a report.
Is this enough detail?
Thank you,
Claire
Thanks!
Can you share the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)
Have a fantastic day!
Andrée
Hi all, I am trying to build out a formula that will return "True" if the CIF #@row can be found above it in the same column (CIF #) AND the Days Since Created is between 30 - 365 days. All of the formulas I have tried have only gotten me so far as the "AND". Adding in the dates screws it up. The goal is to determine if…
I am getting a lot of REF errors for my predecessors and I can't figure out why. At first I thought I might have REF for predecessors to predecessors but that's not the case. When I export the file into Excel it shows the IDs in the place where it shows REF in SS. Each time I refresh the file I feel like different values…
I am trying to create a sheet summary, where the field is a formula that relies on a contact card within a column. However, it keeps returning a result of "#NO MATCH". The columns involved are, 1:) Priority (symbol column) for Up, Unchanged, and Down, and 2:) Contact Card column. I am trying to get a sheet summary formula…
