How to do a sheet report
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
Best Answers
-
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
-
Thank you Paul, that solve it. Appreciate the help.
Answers
-
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
-
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.
-
Add all three conditions and set it to "Or"
-
Thank you Paul, that solve it. Appreciate the help.
