Forum Discussion
imelendez
Oct 28, 2020Copper Contributor
Multiple Comments on a list item
Hello!
I am trying to give the ability to add multiple comments in a single item on a SharePoint list.
Currently, it only allows for one comment to display. If I add another comment, it will delete the previous entry.
I am sure this is a rather simple request but I just need guidance on where to go to make this possible.
I'll attach some screenshots to provide an example:
I have a screenshot of another SharePoint list where multiple comments have been made possible. This is ultimately what I am trying to achieve:
This is because Excel stores dates as numbers not as text.
"30.04.2024" works because it is a complete date, but "*.04.2024" is not recognized as a date.
Also, the ranges are specified incorrectly.
Use this instead:
=COUNTIFS(A21:A500; "John Doe"; B21:B500; ">="&DATE(2024; 4; 1); B21:B500; "<="&DATE(2024; 4; 30))
1 Reply
Sort By
- Kelly_EdingerBronze Contributor
Hi imelendez - the trick is to add a Site Column - there's one called 'Append-Only' that allows users to add but not edit or delete previous comments