Forum Discussion
ganeshsanap
Feb 21, 2021MVP
All you need to know about Commenting in SharePoint / Microsoft Lists
Microsoft introduced a new feature of Commenting in SharePoint Online lists and Microsoft lists. Using this feature users will be able to add and delete comments on list items. Users can view all com...
- Jan 11, 2024
Actually, how do you get the table that excludes blanks? I see Q5 just says '=LET(', but what does this mean and how does this know to reference Table 1?
If you increase the size of the formula bar you'll see that in Q5 the formula is (I updated it - feel free to re-download the sample I earlier shared):
=LET( n, F5, FilterCol, LAMBDA(col, LET(values, CHOOSECOLS(Table1,col), FILTER(values,ISNUMBER(values),FALSE))), StackCol, LAMBDA(init,col, HSTACK(init, TAKE(FilterCol(col),-n))), Array, IFNA(DROP(REDUCE("",SEQUENCE(COLUMNS(Table1)), StackCol),,1),FALSE), Array )
where you can see the 2 references to Table1
If you want to make it more obvious or for easier maintenance you can use:
=LET( myTable, Table1, n, F5, FilterCol, LAMBDA(col, LET(values, CHOOSECOLS(myTable,col), FILTER(values,ISNUMBER(values),FALSE))), StackCol, LAMBDA(init,col, HSTACK(init, TAKE(FilterCol(col),-n))), Array, IFNA(DROP(REDUCE("",SEQUENCE(COLUMNS(myTable)), StackCol),,1),FALSE), Array )
ganeshsanap
May 28, 2021MVP
List comments are supported only in modern experience.
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
ganeshsanap
Jun 15, 2021MVP
Enabling/Disabling list comments for individual SharePoint lists is now possible.
Check this article for detailed information: Enable/Disable the comments for a SharePoint Online/Microsoft List
- ganeshsanapJun 16, 2021MVP
Now you can @mention your colleague’s in SharePoint/Microsoft Lists item comments 💬
- Get a colleague’s attention to an list item by @mentioning them within list comments
- Person will receive an email notification with a link to the list comment
Read more this feature at: SharePoint Online/Microsoft Lists: @mention people in list comments
- AKBSep 02, 2022Brass Contributor
We have noticed that the "Go To Comment" link in the email notification goes to a classic view of the list item, and this does not support comments, so they are not visible. Does anyone know how to make it go to the Modern view of the list item, with comments?
- ganeshsanapSep 02, 2022MVP
AKB Try setting list experience to "New experience" from List settings > Advanced settings.
Are you using any classic experience columns (like Location, etc.) in list?
Please consider giving a Like if my post helped you in any way.