I am using Smart Sheets for Paid Search requests. So, when an AE submits a request for their client, we ask them for specific URLs to be entered. In the sheet where they enter in their URLs (via an Update Request), there are some formulas (vlookups) that we use. For the most part, those work fine, but there are times when I need to go in and update the formulas - either because I forgot something or a new workflow presented itself.
Here are the two challenges:
- There are nearly 200 clients. I've set them up as separate sheets because they are technically separate clients. That's a management nightmare for me. I was thinking about putting all the clients into one sheet, and then breaking them out individually using a Report.
- I'm using the FIND() function for one of my formulas, and it works...mostly. There are instances where it returns an invalid result because it's looking for just a value to be present, not the exact phrase. An example would be - If my formula was looking for "Search", but the value in the other cell was " Paid Search" - using the FIND() function, it returns the position because it's essentially finding part of the value.
Two questions - For #1 - there has to be a better way (I think) because the maintenance of this is painful. For #2 - is there a different way to use FIND() or a different formula that's better?