Summary Sheet Symbols and Projection Question

Amy Arnold

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%

Link to Smartsheet: https://app.smartsheet.com/b/publish?EQBCT=573c191bfe014a77898ac0eebadb2a83

Thank you in advance 🙌

Amy

Leibel S

@Amy Arnold

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 S

@Amy Arnold

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)

Amy Arnold

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