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

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

It worked. Thank you so much!!

Fantastic! Glad it worked.
Help Article Resources
Categories
Check out the Formula Handbook template!