EXCEL IF FUNCTION TO SMARSHEET
Hi,
I've tried everything and I still can't make a formula work in Smartsheet.
Formula in EXCEL:
=IF(K269>0;IF(K269>J269;"DELAYED";"ON TIME");"")
Formula in SMARTSHEET:
=IF([Doc completed]@row > 0, IF([Doc completed]@row > [Deadline for doc]@row, "DELAYED", "ON TIME"), " ")
So if document completed date is not empty, than use IF([Doc completed]@row > [Deadline for doc]@row, "DELAYED", "ON TIME"), but if it's empty don't return any value.
I've tried to change first logical expresion with <> 0 (not exual to 0) and <> " " (not blank) but I just can't make it work.
Please help me, cuz I'm beginning to have a mental breakdown 😀
Best Answers
-
Hope you are fine, Please add a copy of your sheet or a screenshot (after removing or replacing any sensitive information). This will make it easier for me to provide the appropriate answer to your question.
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:
Status =IF(ISBLANK([Doc completed]@row), "", IF([Doc completed]@row > [Deadline for doc]@row, "Delayed", "On Time"))
the following screenshot show the result on my sample sheet
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"
-
Happy to help you anytime
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"
-
You are welcome and am happy it's worked, you can Vote for me 😀😂😉
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
-
Hope you are fine, Please add a copy of your sheet or a screenshot (after removing or replacing any sensitive information). This will make it easier for me to provide the appropriate answer to your question.
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 for fast respond Bassam.
If document completed date is greater than the deadline than must return 'delayed', if not it should return 'on time'. But also if the document completed cell is empty, than formula should return an empty cell.
I hope I explained it well.
Thank you in advance.
-
please try the following formula:
Status =IF(ISBLANK([Doc completed]@row), "", IF([Doc completed]@row > [Deadline for doc]@row, "Delayed", "On Time"))
the following screenshot show the result on my sample sheet
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"
-
Happy to help you anytime
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"
-
@Bassam.M Khalil IT'S WORKING!
I don't know how to thank you enough for fast and helpful answers Bassam. 😊
Wish you all the best!
-
You are welcome and am happy it's worked, you can Vote for me 😀😂😉
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 for your support
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"
-
@Bassam.M Khalil My pleasure 😏
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 466 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives