My goal is to have a UNIQUEID(), but I want the company that produces the item to have their abbreviations right in front of the UNIQUEID().
Thanks, I tried this expression “CONCATENATE(SELECT(Company[Abv.], [Company] = [_THISROW].[Company]), “-”, UNIQUEID())”
But I got this error message: “Expressions in schema ‘Quote_Schema’ have a circular definition. Check app formulas and initial values for column ‘Quote_ID’”
Would you know by any chance if it is due to the company being below Quote_ID?