-
average formula is not working to calculate total retention and total turnover
First row is retention rate and second row is turnover and it keeps giving me an error. Below is the formula i am using for average this is the formula i used to get turnover percentage: But every time I put the average I get an error. Can somebody please help.
-
Search criteria in multiple sheets
I have created a Master Project sheet for three (3) different teams' projects (Team A, B, C). Common fields (columns) include "Project ID", "Project Manager", "Project Category" and "Target End Date". I now need to search the Project ID in all three (3) teams' sheets, matching the ID entered in a fourth (4th) Master…
-
Update data in one sheet from another sheet that updates daily?
Hi there, I have separate product sheets (70 of them!) for each product a division creates. Each row in the sheets has a unique line item number. The first 23 columns contain data pulled from one of our systems, including the line item number. The remaining 26-40 columns contain data that's managed manually. I have another…
-
Creating a formula to show status based on time of input date
Hello all, I am trying to create a formula. I need the status of a field to change color to indicate when its time to perform a task, which is based off of the input date and would change two weeks after. For example, if the task was done 08/14/23, that date would be added manually to the row and the status in the row…
-
How to combine these?
Need the formula to say: If Completed - Green If Canceled - Gray If In Progress - Yellow If Not Started - Red If On Hold - Yellow If In Progress, Not Started, or On Hold and and today is greater than End@row - Red Here is what I have.... Works fine. Now need to add in the last bullet and I'm stumped. =IF(Status@row =…
-
Is it possible to URL-Query an embedded form?
I am wondering if it is possible to prefill an embedded form on a dashboard by referencing the form in the dashboard URL?
-
Automatically change Parent status to display Children status; still be able to change Child value
Hello, I have this formula =IF(CONTAINS("In Progress", CHILDREN()), "In Progress", IF(AND(COUNTIF(CHILDREN(), "Completed") = COUNT(CHILDREN()), COUNTIF(CHILDREN(), "") = 0), "Completed", IF(OR(COUNTIF(CHILDREN(), "Not Started") = COUNT(CHILDREN()), COUNTIF(CHILDREN(), "Not Started") + COUNTIF(CHILDREN(), "") =…
-
Index Collect Formula for Dates resulting in Invalid Value Error
Good afternoon, I am trying to use an Index Collect formula to collect dates that have dependencies. Here is the formula I'm using: =INDEX(COLLECT({Portfolio Summary | Actual Start}, {Portfolio Summary | Project Number}, [Project Number]@row), 1) + "" I can confirm that the formula cell is a date column, as well as the…
-
If all Child rows = "Complete" change Parent to "Complete" and send to new sheet
Hello! I have an automation that sends "Complete" Parent columns to a new sheet (my "Closed Orders" sheet). I also am setting up a formula for when all Children status' are set to "Complete" it automatically switches the Parent row to "Complete". What I am wanting to do is send ALL rows including Parent and its Children in…
-
Change Date column if new row is added after hours
Hello - We have a simple ticket system and if a ticket request from a form comes in after 4:00pm, we don't start the ticket until the next day. Case: Form Entry happens at 2:30pm on 07/27/23. Start Date column should read 07/27/23. Form Entry happens at 4:30pm on 07/27/23. Start Date column should read 07/28/23. So we want…