Best Of
Re: [Need Help] Lookup/Index matching for Horizontal Data
There is no limit to the number of nested IF statements. The only limit you could run into there would be that a formula cannot exceed 4,000 characters.
What you will want is a series of INDEX/MATCHes linked together with IFERRORs.
=IFERROR(IFERROR(IFERROR(INDEX({1st Type Column}, MATCH([Phone Number]@row, {1st Phone Number Column}, 0)), INDEX({2nd Type Column}, MATCH([Phone Number]@row, {2nd Phone Number Column}, 0))), INDEX({3rd Type Column}, MATCH([Phone Number]@row, {3rd Phone Number Column}, 0))), INDEX({4th Type Column}, MATCH([Phone Number]@row , {4th Phone Number Column}, 0)))
Paul Newcome
Re: Easily open the record detail panel from a cell in table view
Ooooh @Lekshmi Unnithan - I really like this feature!!
MCorbin
Re: What formula will pull client specific data from one sheet?
Lol, no worries. Your initial solution worked for me, so I used a combination of yours and his. You guys saved me so much time and effort.
Malcolm Jackson
Re: Conditional formatting multiple columns at once.
Hi,
I hope you're well and safe!
I agree, and in the meantime, here's a possible workaround. I'd recommend the fantastic add-on, which makes this possible (+ many other features).
SSFeatures from the brilliant Nathan. @SSFeatures
Would that work/help?
Also, Please submit this as a Product Feedback or Idea (If it hasn't been added already) when you have a moment. Please share the link to the Idea here so that others and I can add our votes.
I hope that helps!
Be safe, and have a fantastic day!
Best,
Andrée Starå | Smartsheet Expert Consultant & Partner / CEO @ WORK BOLD
✅ Did I help answer your question/solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer. I appreciate it, thank you! 🙏
Andrée Starå
Re: Working with Project Management Office
Will do, I have a "pro" developer appointment next week. I got on zoom earlier this week, and the rep was helpful, but I think was stumped by the root cause. We tried to re-write the formula using the data from the Project Intake Sheet, but I don't think that's right.. Personally I think there are sheets missing from the package, like the mystery "portfolio summary data".
I'm actually going to try and download it again, just for completeness sake.
I should ask since yours seems to work:
- when did you download your package?
- can you find the portfolio summary data, or can you open the reference in the formula?
Cheers,
Pete Spin
Re: Table view initial release is now generally available for all customers!
Thanks for the feedback, AHE! We agree. Improving performance is priority #1 for table teams. There's been some good progress recently and we're excited for a smoother and faster scroll experience to come to table very soon. Please keep the feedback coming!
tyson
Re: July Question of the Month - Join the conversation and receive a badge
My personal goal is to get healthier, too. I say too because I’ve noticed that many people here have set similar goals for themselves. So far, so good—and I hope that’s true for everyone. Wishing you all Godspeed in reaching your goals!
lav_bratis
Re: July Question of the Month - Join the conversation and receive a badge
One thing I had been working on over the past few years when I was working from home a lot more was running a 5K each month. I'd missed Jan & Feb a couple years in a row (for good reason, due to temperatures), but I caught it this year and have verbalized it at my staff meetings at work. My colleagues are able to hold me accountable (and are welcome to join in the festivities). I am 7 for 7 in 2025 for running a 5K each month with the goal to get 12 for 12 this calendar year.
Jake Gustafson
Re: Referencing an imported sheet
Happy to help!
I forgot about another solution.
I'd recommend the fantastic add-on, which makes this possible (+ many other features).
SSFeatures from the brilliant Nathan. @SSFeatures
Would that work/help?
✅ Remember! Did I help answer your question/solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer. I appreciate it, thank you! 🙏
Andrée Starå
Re: Countifs Formula Referencing Another Sheet
Hi,
To add onto all the great information that Kelly provided, I used a "HAS" formula to ensure that all cells with "Active" were counted, even if another word was also in the same cell as opposed to counting cells that only had the word "Active" in them.
Also keep in mind that when you manually insert your Sheet reference, you should select the entire column by clicking the header, to ensure that all rows are captured as new data is entered...assuming you want the full column of data and not a small portion.
Range 1 should be the Division column, and Range 2 should be the Status column in your reference sheet.
=COUNTIFS({Certified Sheet Roster Range 1}, "Eastern", {Certified Sheet Roster Range 2}, HAS(@cell, "Active"))
Amanda Alv