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"))))
Best Answer
-
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().
Answers
-
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")))
-
thanks a lot, I have removed one of them, but it gives my #invalid operation
noting that with )))) it gives #unparseable
-
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().
-
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,,,,,
-
Awesome! Glad it worked out!
Have a great day.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!