IF formula


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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!