Sign in to join the conversation:
Hi!
I have two columns. One if the Due Date and the other is the Completed Date. I would like to set-up an equation where it counts the number of times an item was completed late (after the due date). Is this possible? If yes, what is the equation?
Hmmm. I swear I know a better way of doing this, but I am having trouble getting anything to work. To do this quickly, you could create a helper column and use the following IF statement =IF([Completed Date]@row > [Due Date]@row, "late")
That will write the word late in the row... then you could do a simple... =Countifs([Helper Column]:[Helper Column], "late")
You could do this with the followting equation:
=IF([Completed Date]3 > [Due Date]3, 1, "")
This will put a 1 in the column if the Completed Date was after the Due Date. Then sum the column.
Here is an example sheet https://app.smartsheet.com/b/publish?EQBCT=d3c78d81b9424434a84055dfa1e2f28d
Comparing two (or more) columns for a count at the row level without a helper column is possible with an absurd amount of nested COLLECT functions which also happens to be rather inflexible and easily broken.
I have tested and dug through the forums here and tested some more, and the best thing by far I personally have found has been to use a helper column to compare the cells at the row level and then count the helper column.
If you can find a different way, I'm all ears. Adding extra stuff in after a sheet has been in use enough to have a few thousand rows is rather tiresome.
Hi All, I have a project plan with a column called "Owner" that has a column type of contact list. The contacts are from multiple companies. It's a large project plan. I have created columns that have a column type of checkbox. I want to check the box if the owner is from a certain company (which can be determined by the…
Hello, I am trying to use JOIN-COLLECT to populate a cell with a contact by pulling from another sheet. However, when I use this formula it populates the cell with the name of the contact as a text string, but does not populate the cell with the contact itself. Both the column of cells being populated and the column the…
Hello Community, I need to create a report that shows capacity by month. My sheet tracks resource allocation on projects with resource start and end dates. (We can't afford the Resource Management module so we're doing it in Core SS). I've been asked to do a "heat map" of sorts where each column is a month. For each row…
