Make the "last private comment date" and "last public comment date" for ideas available for reports.

Currently, selecting the "Last idea public comment" gives both the date and comment in a single field, which can't be used in a calculated column. I want to build calculations using the date for tracking SLAs but I'm not able to isolate it in a calculated column.

Ideally, the solution should split this field into two, one field for the date and another for the comment itself

ADMIN RESPONSE

Oct 18, 2024
Ideas reports have two new columns:

Idea last vote date

Idea last portal comment date

These can be filtered and sorted to help find stale ideas and update them as needed.

Attach files

Enter a subject

Ashley Beard

Reply
| Aug 22, 2023

I'd like to create a report of trending ideas based on comments and votes in the last XX days. As of today, I can get the Idea Vote Created Date, but as described above the idea Comment Created Date. The Comment created date is visible, but attached to the comment. I've tried work around by creating custom calculation, but comment fields are not availble for use with date functions.

0 reply Hide replies