hjarriaran · Customer Care Specialist · ✭✭✭

Overview

Overview

Roles	Member
Badges	10

About Me

About Me

Country	United States
Title	Customer Care Specialist
Industry	Healthcare
Area of Expertise	Ticket Systems | Workflows | Process Management
About Me	9 years of experience in healthcare management, projects, and business processes.

Analytics

12

Posts

63

Visits

476

Points

Sep 12, 2023

Join Date

Feb 20, 2025

Last Active

Reactions

• Awesome 1

  1

• Discussions4
• Comments8

Discussions

• Check Box Across Sheets

  Hi, I have two sheets, one is an intake sheet and the other is a metrics sheet. Metrics Sheet Plan has an OR(ISDATE( Formula to raise flag is a date is entered Agents has an IFERROR(INDEX(DISTINCT for…

  

  Answered ✓

  References

  IF(AND

  IF(

  Formulas and Functions

  12

  Oct 21, 2024

  3

• Help with using Networkdays as a column formula

  I want to create a column Formula that captures the Start Date and End Date in Networkdays but does not show the Invalid Data Type error for every unused column. Trying to do this without using depend…

  

  Answered ✓

  Formulas and Functions

  323

  Dec 7, 2023

  2

• Can I combine two COUNTIFS formulas if there is a Date Range?

  I use this formula to identify how many Requests a certain Division entered. =COUNTIFS({Divisions}, [Request Entered by]@row, {Request Type}, "Template Request") I want to combine it with this formula…

  

  Answered ✓

  Formulas and Functions

  151

  Sep 14, 2023

  6

• Needing a formula that shows how many requests get entered each month

  I am building a ticketing system and need to identify how many specific requests get entered each month by a specific department. It would need to use the Request Type "Template Request", the Division…

  

  Answered

  Formulas and Functions

  143

  Sep 13, 2023

  3