How to run a formula if a cell has specific value

kim b

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")))))

Heather Duff

Hi @Kim Bowie,

Try this:

=if([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)),"")

This translates to:

If New Rate D is equal to 5 in this row, calculate the New Rate 3 date in this row plus the number of years listed in New Rate D. If New Rate D does not equal 5, leave the cell blank.

I wasn't certain where the "1" came in...but hopefully this will do the trick for you. Let me know if it works.

Best,

Heather

kim b

It worked. Thank you so much!!

Heather Duff

Fantastic! Glad it worked.