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
Check out the Formula Handbook template!