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
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.
Thank you Paul, that solve it. Appreciate the help.
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"
When managing a PMO. is it considered a best practice to establish an individual workspace for each project? If this is advisable, is there a method for setting up an automated recurring backup for all projects without having to do them individually?
Hello all! I have an automation workflow set up to record a date when a particular column changes to a specified value. Essentially I need to record a date when the "Current Stage" column changes to "Reevaluate/Schedule Final". See the workflow trigger screenshot below. I created this workflow and tested it on 11/16. It…
I use Outlook with my company. When a tagged email comes in from Smartsheets, I click on the "reply in Smartsheet" and it won't take me to any conversation box. It just opens the page, but not on the line that I need. Why is this happening? I updated this morning. Also, I get an Error message sometimes.
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.