How to find the value of one cell from looking at three columns

miaha
miaha ✭✭
edited 05/25/23 in Formulas and Functions

Hi everyone I am trying to create a formula where it utilizes three columns to pull a value of one cell from the row.

Ultimately what I am trying to accomplish is create an formula where there are three columns in a report (Year, Month, and Average Amount)

Every month a new row will be added and a formula I am trying to create a formula in a new cell to feed into a dashboard

The Formula will first look for the specific year so for example 2023, and then it will look for the most current month which would be numbered through 1-12. After it finds the row with the most current month it will pull the value from the Average Amount Column every time a new month is added is there a formula that can do this?

This is what I currently have so far

=IF((([year],2023) AND if([month], 11)), [Average_Amount]@[month]row))

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!