Forum Discussion
Using a formula in a table and getting #spill
=TEXTJOIN("",TRUE,"NWJDC"&SEQUENCE(COUNTA($B2),,1000,1)) It appears I am able to continue the formula along in the table but I am not getting the correct result. I want a sequential number to follo...
Joseph715 Yes, dynamic array functions like SEQUENCE do not play well with structured tables. However, is this what you are trying to achieve in the IR Number column?
="NWJDC"&ROW(B2)-ROW($B$1)+999
Or, if you want to use structured table references:
="NWJDC"&ROW(Table1[@])-ROW(Table1[#Headers])+999
The results would look something like this:
| IR Number | Date | Time |
| NWJDC1000 | 11/14/2023 | 3:00 PM |
| NWJDC1001 | 11/25/2023 | 5:30 PM |
| NWJDC1002 | 11/30/2023 | 1:15 PM |