How to do a sheet report

Iris

I am looking to conduct reports that I can send to my manager based on task that are open, pending or in -progress. I also, if I need to apply a formula, I have problems understanding the (what if, or If this then that) structure.

Thank you for your help

Iris

Eva

Hi @Iris

You can create a report based on certain fields from your sheet. When you create a new report, enter your source sheet, and then you can just work with the filters. There shouldn't be a need for a formula if your sheet is set up correctly.

Eva

Iris

Thank you Paul, that solve it. Appreciate the help.

Eva

Hi @Iris

You can create a report based on certain fields from your sheet. When you create a new report, enter your source sheet, and then you can just work with the filters. There shouldn't be a need for a formula if your sheet is set up correctly.

Eva

Iris

Hi Eva, thank you. Yes, I have found the report that I need. But, I am having problems applying the filter. I have a status column in which I need to all (Open, In-progress or pending) items from the sheet. I am not sure what filter to use in order to get that information.

Paul H

Add all three conditions and set it to "Or"

Iris

Thank you Paul, that solve it. Appreciate the help.