-
IF Match formula failing. Can you use Children as the test to search?
=IF(FIND("Fail", (CHILDREN([Subtask Status]231))) > 0, "Failed Subtask", IF(Column231 = 1, "Pass", IF(Column231 = 0, "Not Started", IF(Column231 > 0, "Review In Progress", IF(Column231 < 0, "Review in Progress"))))) The above formula is returning #Invalid Data Type I also tried to break the formula down into two parts to…
-
Working Instructions
Hello, Happy Friday! Some column headings that i have set up could benefit by having additional instructions pop up to aid the person completing the sheet with best practice. can this be done please?
-
Report not picking up all checked Star symbols
I am running a report and using a Star symbol to filter what should be picked up from my sheet. The report is picking up all rows with stars checked except one. I have confirmed this row is checked. I have removed the Star filter to show all data and it works just fine, picking up this row. But when I go back to filter by…
-
Need help with a formula
here are the formulas and a look at the Spreadhseet. The Column labeled Column has the following formula =SUM((COUNTIF(CHILDREN(Passed10), 1) / SUM(COUNT(CHILDREN(Passed10))))) The current formula in the Status column for the Exception Rules row10 is =IF(Column10 = 1, "Pass", IF(Column10 = 0, "Not Started", IF(Column10 <>…
-
If & AND equals checkbox
Cant get my formula to work =( Please help =IF(AND([Team]28 = "Street Lighting", (NOT(ISBLANK([Quote Sent Date]28)), 1, 0))) If Column 1 (Team) contains text "Street Lighting" and Column 2 (Quote sent date) is not blank, Check the box Thank you in advance
-
Locked columns
When you lock a column, is the person that created the form the only person that will be able to update that column? I have a column that I want one of the people that I will share the report with to be able to edit the column.
-
#INVALID DATA TYPE
Hi All! I have two cells next to each other, Date Assigned and Date Due. When I add the date assigned date, I want it to auto populate the Date Due as 3 business days in the future. My formula works =WORKDAY([Date Assigned]86, 3) but when I have no date in the Date Assigned cell, the Date Due says #INVALID DATA TYPE. Is…
-
Bug: Report formatting inconsistent
I have conditional formatting in the sheet based off of this [Hrs Over SLA] column. The conditional formatting is correct in the sheet but incorrect in the reports for only some rows (see circled for example, where -67 is highlighted on some rows but not in others) How does one resolve this issue?
-
Report ignoring "is blank" parameter
Hi all, We have a report that is suddenly not functioning properly. The report pulls all projects that do not have a Start date and has been functioning without issue until this week. Two of the newest projects given dates are still showing up in the report after deleting and re-entering, refreshing the report, rebuilding…
-
Linking a drop down cell to the workflow
I have a drop down status cell on my customer sheet. I would like the info in this cell to be linked to the Workflow sheet in the status cell for each customer. I have tried to go to the Workflow status cell for a customer and link in from the customer sheet, this works and when the customer sheet status cell is changed…