what is the wrong with this

=IF(AND([total]@row = 100, TODAY(0) < [done]@row), "qualified", IF(AND([total]@row < 100, TODAY(0)< [done]@row), "under-qualification", IF(AND([total]@row < 100, TODAY(0) > [done]@row), "not-qualified"))))

Find more posts tagged with

Accepted answers

Dan W

Sometimes saving and refreshing helps. I got it working in my test.

=IF(AND(Total@row = 100, TODAY() < Done@row), "qualified", IF(AND(Total@row < 100, TODAY() < Done@row), "under-qualification", IF(AND(Total@row < 100, TODAY() > Done@row), "not-qualified")))

I also removed the 0 In TODAY(0), Leaving it as TODAY().

All comments

Dan W

To many ) at end. remove one

=IF(AND(total@row = 100, TODAY() < done@row), "qualified", IF(AND(total@row < 100, TODAY() < done@row), "under-qualification", IF(AND(total@row < 100, TODAY() > done@row), "not-qualified")))

ahmedsaad

thanks a lot, I have removed one of them, but it gives my #invalid operation

noting that with )))) it gives #unparseable

Dan W

Sometimes saving and refreshing helps. I got it working in my test.

=IF(AND(Total@row = 100, TODAY() < Done@row), "qualified", IF(AND(Total@row < 100, TODAY() < Done@row), "under-qualification", IF(AND(Total@row < 100, TODAY() > Done@row), "not-qualified")))

I also removed the 0 In TODAY(0), Leaving it as TODAY().

ahmedsaad

yeeeeeeeeeeeeeeeeeeeeeeeeeh, it works

thank you so much Dan, I have copied your formula

my problem was the property of date column was assigned as text.

thank you,,,,,

Dan W

Awesome! Glad it worked out!

Have a great day.

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.