Forum Discussion
Week Number Sequence
try to add a custom column using this formula:
e facce sapè
I'm not sure I understand what your difficulties are. Try copying and pasting the script into the advanced editor and see if the resulting table is what you wanted. If not, explain better what you expect.
Shall I keep the column names as it is. What should I change if I put in the advanced editor
I had pasted it and it shows me error - token error.
I just copied and pasted the script and this is what I get:
If you want help, explain more precisely and show with pictures what you did and where the error arises. Attach your advanced editor
Questo il mio:
Anonymous
1. Below picture - with Error. I change "Column1" to "Date" - Could you check this, if it is right.
2. In the picture you had mentioned - will weeks go beyond 53 weeks... like 54, 55, 56.
The error that is shown when I click "Show Error" is let
it looks like you did a lot of transformations before using my script. it is too difficult to tell from a picture house wrong. Certainly missing a comma, for how and where you entered the script. But even adding the comma I don't think it would be enough. To get help you must provide a starting table, even with fake data and show a table with the expected result, otherwise it is not possible to follow you. Also try to upload so that your script is copyable after cleaning it of sensitive data.