Report of all comments in cells and/or sheets

leiti373

Hi to all,

as this is very new to me, maybe kind of a silly questions. Research didn't bring what I wanted.

I think I want a very simple thing :) Just create a report or Excel or whatever of all conversation comments of rows and the whole sheet. And additionally all "latest comments" of rows and the whole sheet.

Any advice how to do that? Is this even possible?

Thanks,

Mrakus

Andrée Starå

Hi @leiti373

I hope you're well and safe!

You can export the sheet to Excel or similar.

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

leiti373

Hello Andrée,

thanks - all good. Hope the same for you :)

Yes, export is a partial solution in terms of getting latest comments etc.

I'd like to limit the data being exported so I thought of creating a report. And this reports should colelct all comments in rows and/or sheet.

Cheers,

Markus

leiti373

Hey there,

any hints on this?

How do I get a report on the discussions per line/task in a sheet?

Thanks,

Markus

Matt Johnson

Hi @leiti373

You could reduce the report down to just the primary column and then export it to excel. On the 2nd tab, all the comments will be there with the row numbers they go with. I think the 2nd tab on the exported excel file is what you are looking for.

I hope that helps.

Matt

Ken Armstrong

Hello Have you tried creating a new column and using the "Latest Comment" Column type. Once that is in place you can create a report and pull in that column. Exporting into excel will also work giving you a separate tab for all the row comments.

leiti373

Hello @Ken Armstrong ,

sorry I was offline a couple of days.

Yes that basically works, thanks. The thing is, that instead of the line numbers where the comment belongs to, I'd need the name of the task. So I'm able to filter/sort/cluster in Excel. Just line numbers and comments unfortunately is not enough.

Any formula or so, where I can assign line number and task name?

Thanks a lot,

Markus

Andrée Starå

@leiti373

You can set up the report to include the necessary columns and then export it to Excel from the report instead.

Would that work?

✅Please support the Community by marking the post(s) that helped or answered your question or solved your problem with the accepted answer/helpful, Insightful/Vote Up/Awesome. It will make it easier for others to find a solution or help to answer!

leiti373

Hi @Andrée Starå ,

would you please be so kind and explain how to do that? Somehow this did not yet work for me...

Thanks!

Cheers,

Markus