Jessb9187’s Profile

Community member since November 2018

ABC Financial
Area of expertise
Financial Management
About Me
I'm a Smartsheet newbie! I am from Illinois and I work in IT.



I am trying to combine these two functions to find an average number but only if it meets a specific criteria. For example, I have cases worked that can be canceled for 3 reasons. If the case is canceled because of a "No contact" with the client, I need to know the average number of days the



Smartsheet newbie here:)

I was trying to use a simple SUMIF formula to calculate the total number of days for a specific field. For example: I want to add all the days or duration for all projects that were labeled as "Conversion" together to calculate the total number of days spent on all