Hi, I'm trying to reference a cell that contains a dollar amount based on a date range.

Rover4679 ✭✭✭
edited 12/02/22 in Formulas and Functions

This is what I'm trying (unsuccessfully to accomplish)

=IF([DATE SUBMITTED]@row >= DATE(2022, 12, 1), [DATE SUBMITTED]@row <= DATE(2022, 12, 28), "PO Amount Including Change Orders"

Looking for the amount in "PO Amount Including Change Orders" to show up if the cell "Date Submitted" falls within the date span.

Any ideas?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!