Formula Help Needed - Return "50" if date is within a range AND another field is not blank

Gtaylor31

Hello!

I've been working on this formula for hours now and could use some help. I have a column called "Program Date" and a column called "TR". If Program Date is between 12/1/24 and 4/30/25 AND TR is not blank - then I need it to return the value "50" in my "Cost" column.

This is where I am at so far:

=IF(AND([Program Date]@row >= DATE(2024, 12, 1), [Program Date]@row < DATE(2025, 5, 1), IF(NOT(ISBLANK([TR]@row)))), "50", "")

Any help would be amazing!

heyjay

Lets include your TR inside the AND statement.

=IF(
AND(
  [Program Date]@row >= DATE(2024, 12, 1), 
  [Program Date]@row < DATE(2025, 5, 1), 
  NOT(ISBLANK(TR@row))
), "50", "")

heyjay

Lets include your TR inside the AND statement.

=IF(
AND(
  [Program Date]@row >= DATE(2024, 12, 1), 
  [Program Date]@row < DATE(2025, 5, 1), 
  NOT(ISBLANK(TR@row))
), "50", "")