Return value from another sheet based on 2 criteria

Options
brhea110891
brhea110891 ✭✭✭✭✭

I'm seeking to write a formula that returns the value in the cell for column "hours reported", when the criteria is met in two other columns.

Here are the specifics:

Sheet B is dynamic where the 3 columns referenced are 1) name of the project, 2) is a date and 3) are hours reported

In Sheet A, I want to return the hours reported if the project name is the Project name@row and the date is within the last 7 days.

How would I write this?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!