# Summary Sheet Symbols and Projection Question

✭✭✭✭
edited 07/18/22

Hi, I am trying to do a few things.

First, I would like to pull symbols into the Sheet Summary based on the following criteria:

• Most Recent Entry for Site A.
• Pull symbol from the "▲ ▼" column.

Second, pull the...

• Most Recent entry for Site A.
• Pull symbol from the "Status of Goal" column to sheet summary.

Lastly, I would like calculate "the number of weeks" before the goal is reached based on the following criteria:

• Using the weekly "Intake Size" (i.e. Site A = 12)
• How long would it take to meet the "Goal to Reach" (i.e. Site A = 345)
• If the weekly turnover rate of 3%

Thank you in advance 🙌

Amy

Tags:

• ✭✭✭✭✭✭

Direction: =INDEX(COLLECT([▲ ▼]:[▲ ▼], Site:Site, @cell = "Site A", [Most Recent]:[Most Recent], @cell = 1), 1)

Status: =INDEX(COLLECT([Status of Goal]:[Status of Goal], Site:Site, @cell = "Site A", [Most Recent]:[Most Recent], @cell = 1), 1)

• ✭✭✭✭✭✭

Direction: =INDEX(COLLECT([▲ ▼]:[▲ ▼], Site:Site, @cell = "Site A", [Most Recent]:[Most Recent], @cell = 1), 1)

Status: =INDEX(COLLECT([Status of Goal]:[Status of Goal], Site:Site, @cell = "Site A", [Most Recent]:[Most Recent], @cell = 1), 1)

• ✭✭✭✭

@Leibel Shuchat those formulas worked perfectly, thank you! 🙌

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!