I need to be able to generate a simple format based on the data that exist in smartsheets. I store information such as news updates and I would like to be able to create a report that generates the text formatted in a specific way.
For instance if I have the columns and 3 rows.
- Publish Date
- Category
- Title
- Body Text
I'd like to be able to generate the output so it looks like the following. Is it possible to export this kind of format directly from smartsheets?
If not possible are there 3rd party integrations/tools that would allow me to do this? Right now the only way I can think of it is to export it to excel then run a macro that creates a word doc or txt file.
Any help would be appreciated!
1/1/2018 - Music
Article 01 Title
Body text goes here. this is where all the text goes for the article
2/1/2018 - Art
Article 02 Title
Body text goes here. this is where all the text goes for the article
3/1/2018 - Animals
Article 03 Title
Bod text goes here. this is where all the text goes for the article