If Function

I've tried everything. I'm sure it's a simple fix.

If Type = New, then Store Open Date needs to be OPS T/O + 4 days

If Type= Remodel, then Store Open Date needs to be OPS T/O + 2 days.

HELP! Please. Thank you.

=IF((Type@row="New"), ([OPS T/O]@row+4), (Type@row="Remodel")([OPS T/O]@row+2))



Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!