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

Find more posts tagged with

Accepted answers

All comments

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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.