Help needed with VLOOKUP or IF Formula


I am in need of a formula to reference another sheet and bring back either 1 value if there's only one for that cell or show something as "varies" in case there are more results for that value. For example, I have resource John Smith working on 2 different projects, in this case I want the formula to just say multiple and not bring back the actual project. While for Jane Doe who only has one project, I want the formula to bring the current project on this other sheet. Any help is appreciated! Thanks in advance

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!