Clay Icon
Join the Community
02 Support

Hi Arturo O.; I was trying to pull the name of the last job a person w...

Avatar of KC F.KC F.
·
·

Hi Arturo O.; I was trying to pull the name of the last job a person worked at prior to their current job. The formula is picking up most but not all of the data. Same with the end date of that role. Any ideas why? thanks!

5 comments

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    Hey hey! Can you drop the URL for your table here? (if applicable) 🫶 Don't worry, only admins will be able to open your table 😉

  • Avatar of KC F.
    KC F.
    ·
    ·

    The column headers I need help with are 'Name of Last Company' and 'End Date of Last Company'.

  • Avatar of Arturo O.
    Arturo O.
    ·
    ·

    Hey KC, sorry for the delay! I’ll check it out and see if there’s anything we can change to prompt it for this or even tweaking the formula too

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    There we go, I tried a couple of modified prompts, and looks like it's doing a better job now. Let me know if you run into any issues!