Forum Discussion
How do I get text/comments to show on a daily tracker on Excel?
Hello I have been working on a tracker, it has 57 people inputting information on their own tab but I cant get their comments to show on the daily tracker when they've written in their tabs, just sho...
The problem is that you are using SUMIF for text.
try using XLOOKUP (if there will only be 1 cell) or CONCAT(FILTER()) (if there might be multiple cells). For example:
=CONCAT(FILTER('Jamie White'!$N:$N, 'Jamie White'!$E:$E=$A3,""))
or use TEXTJOIN instead of CONCAT if you want to add a separator between the results
Hey thanks so much for your help, it still isnt working, Ive attached 2 photos, I needed it to show comments or feedback per day when I change the date? If that makes sense?