Reference Comment in Formulas

Kevin De Hart

Please add functionality to address comments via formula, such as =countif([Comments]@row, "No Change") to simply count how often in a row a project is listed as "No Change" or how often something is commented on with =count([Comments]@row). This would add functionality for tracking KPIs and Leading Indicators which is currently missing.

Genevieve P.

Hi @Kevin De Hart

Thanks for posting your idea!

In the meantime, have you checked out the Latest Comment Column you can add to your sheet? This will display the last comment added to a row in a cell in a column, meaning you can then use a COUNTIF function on that column.

Here's more information: Add a latest comment column

Cheers,

Genevieve

Kevin De Hart

This would only work on the most recent comment in each column without exponentially multiplying data in helper sheets or writing rediculously long workflows with compounding conditions.

Thank you for the idea though.

Andrée Starå

Hi @Kevin De Hart

I hope you're well and safe!

You could copy the comment to another sheet automatically with a copy row workflow and then use cross-sheet formulas to count how many or similar.

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!

Kevin De Hart

Yes, thank you I am familiar with this workaround as we had discussed it last week.

This causes an exponential and irresponsible replication of data and is not appropriate to the situation, we would be over 1000 lines in less than 2 weeks for our fast-turn projects.

Andrée Starå

@Kevin De Hart

Happy to help!

Ah ok. Yes, it would be best if it was possible in a different way instead.