Formula no longer working

Sarah Underwood

I have had a formula written for over a year and it just broke this morning saying it is now an #invalid operation.

=City@row + ", " + State@row + " / " + [Location Number]@row + " - " + [Comp Short]@row

Parker Oxford

Try enclosing your column names in brackets, I've done so for your formula below:

=[City]@row + ", " + [State]@row + " / " + [Location Number]@row + " - " + [Comp Short]@row

Andrée Starå

Hi @Sarah Underwood

I hope you're well and safe!

Your formula is correct and should work.

Have you checked the referenced cells?

Did that work/help?

I hope that helps!

Be safe and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Sarah Underwood

This has now been fixed.

Andrée Starå

@Sarah Underwood

Excellent!

Glad you got it working!

What was the issue?