Current Task Formula based off certain criteria (symbols)

Frank_Mattiace
edited 12/09/19 in Formulas and Functions

Hi, 

I want to create a formula that would read all rows have a Green symbol and read back the last task name that has green. This would have to be based off the row number and not dates, given not every task will have a start or end date. 

Attachment for context --> I would want the formula to read all of those tasks and deliver back "presentations task" since that is the last Green row. 

Screen Shot 2018-12-17 at 6.28.49 PM.png

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!