Control center global update error

Susan van Niekerk

Hi Brian trust

I have added added a column with a column formulas - the formula is working and giving me the text i need BUT when I go to control centre to add and run a global update it gives me a syntax error on the test run

=IF(NOT(ISBLANK([External Contact]@row)), [Project ID]@row + ", " + [Project Name]@row + ", " + Parent@row + ", " + [Task Name]@row, "")

so basically it is when My external contact is not blank join 3 other column cells together

Paul Newcome

Global Updates with Column Formulas can be a little weird sometimes. My suggestion would be to go ahead and apply it to one project then go check the project to see if it actually went through.

Susan van Niekerk

Hey Paul

Did that and it did not apply the change - I am hoping to do this through global update as i don't feel like updating 105 sheets :-O