Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
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".
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.
