var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Formulas for counting days and automation Q
I have two questionson the attached sample spreadsheet. The sample has some conditional formatting and validation applied.
1)In the attached sample, im trying to count(and categorize) incidents based on number of days the incidents are open(see days open column).
The categories are
count/# of Incidents open 1-30 days
# of incidents open 31-60 days
# of incidents open 61-90 days
and incidents open > 90 days
2) If I insert an entry for closed date field, I want the value in days open column to move to the cycle time coulmn. Is this possible?
Cycle Time= Date Closed - Date Reported
Days Open= Today()-Date Reported
Your suggestions are greatly appreciated,
attached what I think you are asking for