-
Gantt View - Settings requests
Hi, I'm trying to create a dynamic 'To-Do' list (for want of a better phrase), that automatically steps the jobs - i.e. only start task 2 when task 1 is expected to complete. I want to make this as automated as possible, and I understand that dependancy columns do not accept formulas, but wanted to know if there was…
-
Modifying RYG Symbols with Dates and Status
We are trying to create a formula on the Schedule field that will change color to Red, Green or Yellow based on Multiple day and Status selection. For example: If Status is In Progress and End Date is > Today and R - Date is Empty then is Green. IF Status is In Progress and End Date is < Today and R - Date is Empty or a…
-
Managing Resources across multiple projects
Hi All, We have many concurrent projects running at all times. I am looking for ways to manage resource assignments across multiple projects. When I assign a resource for a specific project/task, I want to see if this particular resource is available around those specific dates. Also, I would like to see the global view…
-
HELP WITH INDEX FUNCTION
I have two columns... one with names and one with scores. I need a formula that will show the name of the person with the highest score. Is that possible?
-
Symbols using formulas
Hi there, I am creating a training matrix, so I have employee names down the left and the training programs along the top. I want to set it so that if for example "WHMIS" expires after 1 year then the symbol would go from green to red 1 yr after the "Training Date" and 30 days before the expiry I would like it to go…
-
Using Hierarchy Formulas & Conditional Formatting to Color Code Rows in a Sheet
I’m always interested to hear if someone else has figured out a better way to do something, so feedback is welcome and appreciated! (: Example Sheet: Hierarchy Formulas & Conditional Formatting I like to use colors to help guide me through a sheet and I have settled on a process that works for me. *See Picture* Minimum…
-
Average Days
I am looking to have some metrics set up on a dashboard all around average days to close. I have a column for a sales person, two date columns (one a start date and one a close date) and a column called Workflow Status. How can I do the two following things via formulas: * Filter this first by the workflow status being…
-
Nested IFERROR
I am using the below formula that is working fine: =IFERROR(IFERROR(INDEX({Sales_Parts_1_Description}, MATCH($[Supplier Part Number]@row, {Sales_Parts_1_PN}, 0)), INDEX({Sales_Parts_2_Description}, MATCH($[Supplier Part Number]@row, {Sales_Parts_2_PN}, 0))), "ERROR - CHECK PART #") However, I want to add another INDEX…
-
COUNTIF is double counting rows with multiple assigned contacts
Hello all, I am trying to count rows for one department. This department also has sub-departments. In some rows, it has multiple sub-departments assigned to it. This is my formula: =COUNTIFS({Requests Range 2 - Status}, Category2, {Requests Range 4 - Department}, (FIND("Merchandising", @cell) > 0)) For example, one row has…
-
Need tip for nested formula using IF, AND, and ISBLANK
I have a schedule template with columns for At Risk (red flag on or off), Status (Not Started, In Progress, Complete), and Risk Reason (is it at risk because of Late Start or Late End, or else blank if the flag is off). Here is the Risk Reason we're currently using: =IF(AND([At Risk]@row = 1, Status@row = "Not Started"),…