Forum Discussion

Cattykinsy's avatar
Cattykinsy
Copper Contributor
Jul 20, 2023

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 shows as 0 for all of them, when they've each written a few sentences each in that last column?

 

 

  • mtarler's avatar
    mtarler
    Silver Contributor

    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

    • Cattykinsy's avatar
      Cattykinsy
      Copper Contributor

      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?

       

      • HansVogelaar's avatar
        HansVogelaar
        MVP

        Cattykinsy 

        You probably want to use $A$1 instead of $A3, but column H on the Jamie White sheet appears to be empty, so it's not clear what you want to do...