This the formula I am currently using for a sales recruiting funnel that measures our customer recruitment during different stages.
. =IFERROR(IF(SEARCH("*ADOPTED*",N24,1),"CLOSED")," ")
I need this formula to also look in J24 for a date value >1. If there is a date > 1, I need it to return "LOST".
I have no clue how to do this or if its even possible. Any help would be greatly appreciated.
Best,
CB
Bookmarks