Max Collect Formula

Options
Max Collect.jpg

I am trying to use max collect to display the latest step in a project plan based on the highest value in the "project phase" column that has been marked as green in the "Status" column. I am returning a vlaue of 0 no matter what I try to change here. any thoughts? thanks!

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!