apendix

Copper Contributor

I am trying to use =IF(LEN([Postal Code])=10,LEFT([Postal Code],5),[Postal Code]) and getting spill error can someone help

2 Replies
I believe with the transition to dynamic array being the default method of evaluating formulas in Office 365, that formula won't work within a structured table. Try: =IF(LEN([@[Postal Code]])=10,LEFT([@[Postal Code]],5),[@[Postal Code]])
Thanks