Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Multiple Column Confirmation Criteria to return date from "Order Date" Column
I need a formula for a date formatted column that must return the "Order Date" from the ODate column if the Site Name (Site) is Oak Village, Block Name (Block) is Block 102 and the Floor Level (FlrLvlUnt) is Basement Level. I managed this multiple criteria lookup with SUMIF for number values, but have been unable to do so with DATE values.