I need Help - Trying to do a VLOOKUP Partial Match

Answers

CAS the CSA ✭✭✭

11/20/23

https://community.smartsheet.com/discussion/comment/405890#Comment_405890

@cell returns the same results

0 · Share on Facebook Share on Twitter
Paul Newcome ✭✭✭✭✭✭

11/20/23

@CAS the CSA Are you able to provide some screenshots for reference?

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
0 · Share on Facebook Share on Twitter
CAS the CSA ✭✭✭

11/20/23 edited 11/20/23

https://community.smartsheet.com/discussion/comment/405908#Comment_405908

No, it is sensitive information. I copy/ pasted my formula precisely.

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 formula to update the status based off the % complete?
i.e % Complete is = to 0% then Status should equal not started, if % complete is > 0%, then status should be In Progress, if % complete is = to 100% then the status should equal Complete
Hello! I am trying to make a graph with these dates!
I am using a Grid Sheet and a reference sheet but can not figure out how to get the formula to match. I am using =COUNTIFS([Start Date]:[Start Date], AND(@cell >= DATE (2021, 1, 1), @cell <= DATE(2021, 12, 31))) This is my reference sheet formula =COUNTIFS({OnBoarding Partner Agreements Range 1} [Start Date]:[Start Date],…
Formula for numbering rows based on specific conditions
Hello! I need to create formulas for two columns that number rows based on specific conditions. I have a helper column (Number). First, I want to number rows that: Type is "Focus Group Volunteer" and Internal is "yes." Second, I want to number rows that: Type is "Focus Group Volunteer", Internal is "no", and Patron Type is…