VLOOKUP to Return Value - Duplication Issue

elisabelville ✭✭
edited 11/23/23 in Formulas and Functions


I am needing help with my formula - I have project plan template I am working with. My goal is to get the formula to pull up the Task Names that have a Milestone Flag in the first column.

The problem I am having, the formula works, but only for the first result (first flagged item), and duplicates the task name in each row the formula is in, instead of pulling up the remainder of the flags


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!