IF formula

Wanda Jackson

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

Wanda Jackson

Ok, I've found the answer to my question. I had the Column Type set as 'text' instead of 'date' where the error kept occuring. Sorry for the bother

Andrée Starå

Hi @Wanda Jackson

I hope you're well and safe!

Glad you got it working!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Please support the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!