Hi all,
I have this mobilisation spreadsheet and the formula is mostly working exceptI want it to show "Medical Completed" if the inserted date has passed today's date. If the inserted date has not been met / or its in the future, i want to show "Medical Booked".
Please Login or Register to view this content.
If you see the previous formulas it shows Mobilzed if the date has been met with requirement.
Please help.
Last edited by Byambadorj; 08-22-2017 at 02:38 AM.
Apologies for my bad English. Not my native language.
On which tab and in which column do you want this formula to appear.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Is this workbook showing real client data? If so, then please remove the attachment, desensitise the data and re-post.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
If you opened the excel sheet there is STATUS column in E which goes down. I want one of the options to show "Medical Booked" if <=TODAY()) has not been met; and "Medical Completed" if <=TODAY()) has been met.Originally Posted by alansidman
Please review post #4 as a matter of urgency.
@AliGW - Just did. Thank you
=IF(OR([@[Medical Completed]]>=TODAY(),[@[Medical Completed]]=""), "Medical Booked","Medical Completed")
Now the whole formula is not working, saying "You've entered too many argument" I don't know where its being faulty. Can you please insert on the spreadsheet and copy paste the correct?? Thank you very much.
Trouble is, if you want either one or the other of those returns, by definition they will cancel out everything else.
Try this:
=IF(OR([@[Medical Completed]]>=TODAY(),[@[Medical Completed]]=""), "Medical Booked",IF(AND(ISNUMBER([@[SAP Number Received Date]]),[@[Travel to Site/First day in UB Office]]<=TODAY()),"Mobilized",IF(ISNUMBER([@[SAP Number Provided]]),"Notification Sent",IF(ISNUMBER([@[SAP Number Submitted Date]]),"SAP Submitted",IF(ISNUMBER([@[Medical Received]]),"Medical Received",IF(ISNUMBER([@[Medical Completed]]<=TODAY()),"Medical Completed",IF(ISNUMBER([@[New Starter Alert]]),"NSA Received",IF(ISNUMBER([@[Employment Contract Signed]]),"Contract Signed",IF(ISTEXT([@[Employment Contract Signed]]),"Contract Not Signed","Medical Completed")))))))))
Thanks all. Did some tweak on <= ; = ; >TODAY()) and now its working. Much appreciated. You guys are great & keep it up. Marked as solved.
You're welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks