Hello,
I have an issue, with a table updated every month, that comes with the data without the reference date on each rows, the date stays above the headers on one cell. How should I automatically set this date into all the data bellow? Because I need to send this data to another bigger table.
Please see the example on the picture bellow. I need to set the date on the blue cell into the yellow cells.
Every month the total of rows of data are different.
Thx in advance,
Tanai
Solved! Go to Solution.
If they're all supposed to be the same, you could do a Multi-Row Formula Tool with the following expression:
[Row-1:Date]
Let me know if this would work in your situation or you need another solution.
Cheers!
From your spreadsheet, it looks like you need to reformat your data a fair amount as well. Without knowing how consistent your data is, it's hard to tell exactly how to do this, but attached is an attempt to both format and add the date to every line. Note that this depends on the date being the only data above your table, and the end of your table having with the word "Total".
Take a look, see if it gets you closer.
Thank you danrh!
It worked just fine with my real case!
I just don't know if there exists a simpler path to do this.
But for me worked just great. Thanks a lot.
Since I am using always the report for the current or last month, is there a way to automatically always select (on the input data) the last modified report or the report from the same month as my current date, from my file directory?
Regards,
Tanai
Thanks tcroberts,
It would probably work too.
I've used danrh solution that worked completely for my case.
Regards,
Tanai