Sign in to join the conversation:
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?
I created a spreadsheet and used a couple cross-sheet references in a Countifs formula that will count all past due tasks, and where assigned to a particular person. We then linked that data into a dashboard! Because contact columns are finicky we used an email address and a Full name field to check against the contact column. See screenshot below.
Thank you Mike, I can give that a try! I currently have a report that shows me past due tasks across all my spreadsheets but it changes based on the task getting marked as complete. Ideally, I would be able to create a stats report-- something that could show, for instance, tasks assigned to "John" become past due 25% of the time.
Ah. I see what you mean. That would require tracking the actual completion date and measuring it against the due date. You might want to add a hidden column or a flag that adds text if the assignment or is triggered when the actual completion is past the due date. Then you could divide all the past due assignments that are completed and divide them by the total completed assignments to get a percentage number.
Would that work for you?
BLUF: When I create an Invoice, I need the cell-link to my live price data to be severed. I currently have a Price sheet for my products that is updated frequently. I use Control Center to create Projects, which includes an Invoice sheet. I have a dropdown on my invoice sheet to select a product, and then I use Index…
I've seen many thread with this, none of which have the answer the user was looking for, so I'm starting a new one, hoping this can be an update. I manage a log with many graphic designers who share this log with me. For items not yet on order but have item #'s created, I like to keep them under a parent row neatly tucked…
Hello! I have a user that manages events. When an event is completed, she would like to automatically send an email with a QR code that will take the recipient to Cvent to complete a survey. My thought was to keep the QR code image in a Sheet Summary field and then link to it in the sheet via a column formula, then create…
