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.

sum time total time reported today per production line

Jon Brown
Jon Brown ✭✭✭✭
edited 12/09/19 in Archived 2017 Posts

I have sheet that is being populated by data being entered into a form.

I have columns for "Date" "Production Line (text field)" and "Stoppage Length (time)"

I am trying to come up with a formula that enables me to sum the total stoppage length each day per production line.

I created a formula that uses the sumif formula to look at the whole date column and when the date equals today and the line equals "X" sum the related minutes column. I cant seem to get it to work though.

Assistance from a formula guru would be much appreciated.

Thanks

Jon

 

 

 

smartsheet.PNG

Comments

This discussion has been closed.