Troubleshooting Conditional Formula Issues in Excel

https://app.clay.com/workspaces/199232/workbooks/wb_kdCiGJ9MG9xX/tables/t_FZHko4VeYGnf/views/gv_gb8PJvWFDUdt Column: E01: Search LI Profile

Hey there Andreas thanks for reaching out, taking a look at your formula in column: E01: Search LI Profile, you seem to have changed the format for it. Have you managed to get this working or are you still experiencing issue?

here’s the loom for you! https://www.loom.com/share/f2ea44a8509c47038d211c51d2744d45?sid=5624b3a1-ef43-457e-a67c-3b2a17d5d482

Hey there Andreas thank you for making this loom video taking a look to see what's causing this. Did notice that duplicating the column and entering in this conditional formula will work however, checking to see why the original keeps returning an error