Adding Comments to Dashboard?

tmichelle068

I have a form where the submitter can enter comments they would like the team to know. I am creating a dashboard, and wonder if there is a way to show some of these comments on the dashboard?

What kind of formula would that use? Is that even possible?

Andrée Starå

Hi @tmichelle068

I hope you're well and safe!

You could use the Latest Comment Column and a Report to show them on the Dashboard.

Make sense?

Would 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!

tmichelle068

Would that work if there are places to leave multiple comments in the same row? Is there a way to have it pull the latest comment from a specific column?

tmichelle068

Oh, sorry I think I explained that incorrectly. I am referencing a form for my dashboard, and on that form is an area to leave comments. I want to show those comments that have been entered, not the comment made on the row by someone on the sheet.

Andrée Starå

@tmichelle068

Yes, you can select the column that includes the comment and have it shown with a report in the dashboard.

Would that work/help?

✅Remember! 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!

tmichelle068

Yes, that is exactly what I need! How would I do that? Just reference the column directly from the dashboard?

Also, is there a way to only show comments from the current month?

Andrée Starå

@tmichelle068

You would create a report that filters on the criteria you described and then use the report widget to add it to the dashboard.

https://help.smartsheet.com/learning-track/smartsheet-intermediate/reports

https://help.smartsheet.com/articles/2482269-using-report-widgets

✅Remember! 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!