Hello,

I have pulled and seperated a sting of data on a new tab and would like the Primary Field to include some of the seperated data.

I keep getting the circular error message. I’m struggling to see why this is happening but would love to know is there a work around?

The string contains:

Cost Name–Staff Name–Description of Services

and as been seperated into different columns:

{Cost Name} {Staff Name} {Description of Services}

I would like the Primary Record to contain:

CONCATENATE(datetimeformat({Date},‘YYYY-MM-DD’)," “,{Staff Name},” ",{Cost Name})

For whatever reason, I can add the full string but not the seperated information.

Thanks