Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Owner Task Counting and Reporting
How would I create a formula to calculate tasks complete (last 30,60,90 days), open, past due by owner similar to this screen shot which comes from the Webinar - "Manage and Track Tickets with Custom App".
Comments
-
You will want to use COUNTIFS formulas for some and other math functions for others.
For example:
Count the number of open tasks assigned to Jane:
=COUNTIFS(Status:Status, "Open", [Assigned To]:[Assigned To], "Jane")
This will look to the Status and Assigned To columns and will count the number of rows where Status is Open and Assigned To is Jane.
% Closed (for row 5):
=([Percent Complete]5 + [Cost to Department]5) / [Cost to Department]5
Smartsheet help center article on formulas: http://help.smartsheet.com/customer/en/portal/articles/775363-using-formulas
Let me know if there is a specific formula you are having trouble with.
