Index and Match Formula

Options

Answers

Chelsea Duncan ✭✭✭

06/15/21

That's right! Totally forgot.. sheesh lol. Thanks again!

0 · Share on Facebook Share on Twitter
Paul Newcome Community Champion

06/16/21

Haha. No worries. Happy to help. 👍️

CERTIFIED SMARTSHEET PLATINUM PARTNER
10x Time Savers (An exclusive group that grants you access our Smartsheet master classes, tips, tricks, & much more!)
Training opportunities with my team and I
0 · Share on Facebook Share on Twitter
Andrée Starå Community Champion

09/06/21

@Chelsea Duncan
Happy to help!
I saw that Paul answered already!
Let me know if I can help with anything else!
Best,
Andrée

SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Is there a best practice to convert a dashboard to a PDF?
I've been asked to see if there's a way to make saving a dashboard as a PDF more accurate. I've tried printing/saving as a PDF. Is there a setting so that the area that I have for a list can expand? If our area is too small, then we don't see the entire list. And if we make the area large enough to always contain the…
Autopoluate date information to another cell
I would like to autopopulate a cell in another column with the first 3 letters of the month and the last 2 digits of the year that are in the date column that are now displayed as 07/01/25. Thank you in advance for sharing your wisdom!!
Formula not working - correctly
I tried applying a formula, but the results aren’t coming out correctly. For example, the headset count is showing as 6, whereas there are actually only 3 headsets. I suspect the issue is due to multiple items being listed in a single cell (e.g., "Headset, Keyboard"). Could someone please confirm if the formula supports…