How to run a formula if a cell has specific value

I'm new to the Smartsheet community and need some assistance on a formula.

Goal: If cell = 5, then run the formula; if not, then leave blank. The logic appears straightforward, but I'm not getting the correct return.

Formats: Column New Rate D is formatted to number, New Rate 3 and the cell I want the formula to run in are formatted as 'Date'.

=SUMIF([New Rate D]@row = "5", DATE(YEAR([New Rate 3]@row + [New Rate D]@row, MONTH([New Rate 3]@row, DAY([New Rate 3]@row, "1")))))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!