Sum cells if "Assigned To = Current User"


I am managing a sheet with a bunch of editors.

I’ve set up filters to show only the tasks assigned to them.

There’s a total sum of sales on the top of the page. I want to show this figure based on the user using the sheet. If an editor is using i want it to show his sales figure and if I login i want to see the total sales figure.

Please let me know how to set it up !!

Hi @PIU_KOLLAM_KSWMP , thanks for reaching out and happy to help here! Thanks for dropping a link to your doc in your post. However, it looks like we’re unable to view your doc. Would you mind adjusting the share settings so we can take a closer look at what you’ve already built? Look forward to hearing back.

Thanks for the reply. I’ve figured it out using a formula to filter values :slight_smile: Thanks a lot :slight_smile:

1 Like

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.