Index and Match Formula

Chelsea Duncan
edited 06/08/21 in Formulas and Functions


This formula returns unparseable (formula is based off what I did in excel):

=INDEX([Phase]1:[Comments]57,MATCH(0,[Date Completed]3:[Date Completed]57,-1)+1,MATCH("Phase",[Phase]1:[Comments]1,0))

There are multiple rows of tasks. I want to get the phase that has a date started but not completed, up to the very top row.

Thanks in advance :)

Best Answers



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!