Sign in to join the conversation:
Hi,
I'm new to Smartsheet and I'm having some issues with one of my formulas. I want to get a count of everything where the Status = Completed and then the following:
You will need to use a helper column to establish how the dates compare.
You can then use a COUNTIFS function to include the two sets of range/criteria.
thank you!
Happy to help!
I'm looking to create a formula that will count the number of overdue tasks. This is based on the "assigned to", "status" and "due date". My current formula is =COUNTIFS({[Sheet Name]}, <TODAY(), {[Sheet Name]}, ="[Assigned To]"). However, this is pulling tasks that are due in the past, but are completed.
In the above image the green is the parent line, where some are calculating the child line %'s below, however in the lower half of the image it's not doing so. Any suggestions please? Thanks!
I have a sheet where I query 14 other sheets to collect all sorts of data (unique values from sheet into a column) and in another column I use an Index distinct collect to get all the unique value from those 14 columns, this is the 'Index' column. At some point a user will want to generate a certificate associted with the…
