Collecting Most recent Status (based on most recent date @ topic)

I wrote these, and I cannot seem to get them to work, can someone assist?

To get status date - =MAX(COLLECT({Status Report - Status Date}, {Status Report - Workstream}, [primary column]@row))

to get the scope status for specific topic - =INDEX(COLLECT({Status Report - Scope}, {Status Report - Workstream}, [Primary Column]@row, {Status Report - Status Date}, $[Status Date]2), 1)

I am getting an unparseable message, not sure why, maybe its a primary column issue? Please advise


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!