-
Reports Exportable to Outlook Calendars?
Hi there, Are customized reports able to be published to Outlook 2013? Thank you!
-
Activity status column based on due date and % completion
Team, It will be great if someone can help me to Color Code/Highlight the activities in my smartsheet based on target completion date & % Completion column that is manually updated. What I would like to do is: IF target completion date is in the past & % Completion is less than 100% mark it as “PAST DUE” IF target…
-
Reporting on Tasks Past Due by Person
I'm looking to collect ongoing data/statistics on how many tasks reach past due. I would like to collect this by person assigned and across all projects and then by month. Any suggestions on how to tackle this using smartsheet?
-
Additional workflow/automation actions
Scenario: In our project, we have a weekly reporting cycle. In some of our sheets, we have a field that is "previous status" or "previous actions" or other similar ones, you get the idea. Desired action: have an automated flow where, once the end of the cycle is reached (any configurable date, friday evening for example),…
-
Acceso a Informes con Acceso Incorrecto
Hola, he creado un único informe para que accedan a diferentes usuarios. Estará configurado el informe para que muestre las líneas en la que, la cuenta de usuario coincida con la cuenta de usuario que crea la línea o cuando coincida la cuenta de usuario con una columna con fórmula cuenta. Este informe funciona…
-
Best Formula
I have a construction schedule with start and finish dates. I want the check boxes for the at risk column to automatically check off if the project is late starting or late finishing. Can anyone help me craft the appropriate formula for this? Is there a good formula for this? I was thinking it would be an if then formula…
-
Weekly checks and scheduled tasks
Hi There, my support team has to check 600 - 800 technical setups on a weekly basis. They have to approach all systems physically and do certain routines. We want to use Smartsheet and its forms to easily document that process and generate reporting. We would populate a list with all relevant information and generate…
-
Calculation Formulas on Reports
Our company uses Smartsheet a little differently than most but I am finding it would be very helpful if I could add formula calculations directly to the reports I pull. Currently I have to add the formulas to the sheets themselves, hide those columns and continue dragging formulas down as we add rows. Hundreds of sheets...…
-
Report and Dashboard View of Planned vs Actual progress Task
I have searched the community for some solutions for what I am trying to achieve…and there were lots of information that seemed close to what I am trying to do. Many links that were shared for other blogs, articles, etc., are no longer active. So I am hoping someone from the community can help me put it together. We would…
-
Problem Saving Blueprint
Hello Smartsheet, Reposing in hopes that you can assist me. I've added a new sheet to my Blueprint (I've done this before). The sheet has one profile field (Project Name). I don't need anything on the sheet to report out to anywhere. When I try to save my Blueprint, I receive an error "add more column(s) to reporting…
