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.
Hello I am looking to create a Smartsheet formula that returns the following result: Column A "Created Date" - this column type is a Created date and show results with date and time Column B "Received Date" - this column would round up the "Created Date" and just show date, no time. If the "Created Date" was after 2:00pm…
Trying to create automatic sequential ID numbers based on the date to ship and where the sample goes. Have a general auto numbering Row ID, have (thanks to reading other questions and responses) figured out how to designate a year. Now I would like to number the Internal (INT) shipments separately from the external…
I have a sheet that has data displayed both horizontal and vertical. The primary data is horizontal (date) with information below each date, 4 rows of data. After the data the dates for the next set of data is horizontal with information below it vertical. 1/5/26 1/12/26 1/19/26 1/26/26 JP OS TT LL OS RT RR SS That data…
