79236087

Date: 2024-11-29 06:59:40
Score: 0.5
Natty:
Report link

Please try this formula:

=IF(ISBLANK(Date),IF(ISERROR(FIND("Vol",[Leaver Reason Test])),IF(ISERROR(FIND("Inv",[Leaver Reason Test])),"","N/A"),"TBC"),"complete")

Here is my test result: enter image description here

Reasons:
  • Whitelisted phrase (-1): try this
  • Probably link only (1):
  • Low length (0.5):
  • Has code block (-0.5):
  • Low reputation (0.5):
Posted by: Karley Zhou-MSFT