Formula Help for Displaying Column Text

Audrey Marie

Hi all,

I am creating a sheet and need to display names from a reference sheet if the text value in the same reference sheet is true.

Here is an example of my reference sheet:

Manager	ProjectStatus
Joe Smith	Not Started
John Example	In Progress
Jane Doe	Complete

In my sheet that I'm creating the database in, I need compile a list of the the managers' names if the Project status is either Not Started or In Progress.

Any help would be amazing!

Andrée Starå

https://community.smartsheet.com/discussion/141443/formula-help-for-displaying-column-text

Hi,

I hope you're well and safe!

Have you explored using a Report instead?

Would that work/help?

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Smartsheet Expert Consultant & Partner / CEO @ WORK BOLD

✅ Did I help answer your question/solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer. I appreciate it, thank you! 🙏