Return value if conditions are met

Options

I'm working on a project summary report where I want to pull over the {B2B Mktg - Spend} cell of the sheet I'm referencing where the year matches the parent, quarter matches the metric@row and the row level of that other sheet is 1. See the summary snapshot and formula attempt below. What am I missing?

=IF(AND({B2B Mktg - Year} = PARENT(), {B2B Mktg - Qtr} = Metric@row, {B2B Mktg - Level} = 1), {B2B Mktg - Spend}, " ")

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!