IF formula

Options

I have 2 different sheets with same columns but for different projects. I used this formula for one sheet, but it does not work on the other sheet. Any reason why this is happening? I just need to count down the days remaining for registration. It has worked on all of my sheets in the past, but I can't figure out why it doesn't for this sheet. Thank you.


=IF([Registration Deadline]@row - TODAY() < 100, [Registration Deadline]@row - TODAY(), "")

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!