what is the wrong with this

ahmedsaad

=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"))))

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().

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.