Web TimeSheet administrator would like to report on users' data in the disabled department. However, the administrator wouldn't want to (Disabled) remark next to the department names as it doesn't look good when presenting the users' data to the management.

Use the following formula as a reference and create a new formula with department names suitable to your organization,
If(DepartmentName="HR (Disabled)","HR",
If(DepartmentName="Admin (Disabled)","Admin",
If(DepartmentName="Management (Disabled)","Management",
If(DepartmentName="Customer Support (Disabled)","Customer Support",NumberToText(0)



Refer the attached screenshots for illustrations.


Start a free Replicon trial today based on your business needs

Start Free Trial