Greater than, Less than or equal to formula help, also produce "" when cell is blank
Can someone help me fix my formula;
Goal output
- Task Actual Duration is greater than Task Duration Days then "Longer"
- Task Actual Duration is less than Task Duration Days then "Shorter"
- Task Actual Duration = Task Duration Days then "Expected"
- If Task Actual Duration is blank then " "
Right now my formula doesn't account for the equal to component and doesn't account for if the "Task Actual Duration" is blank.
=IF([Task Actual Duration]@row > [Task Duration Days]@row, "Longer", "Shorter")
Thanks for helping me fix formula, my guess is it needs some nesting which i am not good at.
Best Answer
-
Please try the following formula:
=IF(OR(ISBLANK([Task Duration Days]@row), ISBLANK([Task Actual Duration]@row)), "", IF([Task Actual Duration]@row > [Task Duration Days]@row, "Longer", IF([Task Actual Duration]@row = [Task Duration Days]@row, "Expected", "Shorter")))
the following screenshot shows the result:
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Answers
-
Hi @dgloballab
Hope you are fine, please try the following formula:
=IF(OR(ISBLANK([Task Duration Days]@row), ISBLANK([Task Actual Duration]@row)), "", IF([Task Actual Duration]@row >= [Task Duration Days]@row, "Longer", "Shorter"))
the following screenshot shows the result:
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Thank you @Bassam Khalil Any chance you can add in if they match that it should provide "Expected"?
-
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Please try the following formula:
=IF(OR(ISBLANK([Task Duration Days]@row), ISBLANK([Task Actual Duration]@row)), "", IF([Task Actual Duration]@row > [Task Duration Days]@row, "Longer", IF([Task Actual Duration]@row = [Task Duration Days]@row, "Expected", "Shorter")))
the following screenshot shows the result:
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Thanks so much! works perfectly!
-
Excellent, i will be happy to help you any time.
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!