-
Changing column Property Status (Red, Yellow, Green) when two columns dates are different
I am in need for the status colum 1 (red, yellow, green) to automatically change when column 2 (date) is passed column 3 (date). Can this be done with a formula? I can do "=IF([Approved Required Delivered Date]1 < [Adjusted Delivery Date]1, "Red")", however, I am sure on how to add the other two conditions in the formula.…
-
"SUMIFS=" " Circular Reference Error"
Hello, I figured out how to make work a large formula for =Sumifs. The idea was to add the "target budget" of all projects that would have as Project Manager (PM/RI) "Mari M." and only for the projects that would have an "Status of Request" of ( New, Work in Progress, In Design, In construction, Substantially completed,…
-
Finding the child rows of a parent row
We keep track of team projects on 1 smart sheet. Projects are in parent rows. Task related to these projects are in children rows. We also have ongoing tasks (newsletters, etc) that have a due date of 12/31/19. Here is the formula to determine the number of ongoing projects: COUNTIFS({Project List Range 1}, "Project",…
-
SUMIFS Based on Parent and Children Criteria
Hi there! I am trying to make a master reporting sheet that is just a sum of another source sheet based on specific criteria of parent and child rows. It's a two step SUMIFS that I can't seem to get straight. It would need to be a sum "grand total count", if hierarchy 0 month = specified month and hierarchy 1 matches…
-
Formula help with Sum ifs
Hi, I have done a formula for Countifs =COUNTIFS({July Range unders}, <0, {July Range Manager}, [A/M]1) This works well and returns the correct data, however i now want the total sum of these entries so tried the following: =SUMIFS({July Range unders}, <0, {July Range Manager}, [A/M]1) But this is pulling back an Incorrect…
-
countifs formula stopped working
Hello All, Did something recently change? I have a dashboard that leverages a sheet for various counts. It has been working. I was away on vacation and they are no longer working thowing and invalid error. =COUNTIFS({Aimbridge Report Issues (Resolved)}, 0) – 10 =COUNTIFS({Aimbridge Report Issues (Resolved)}, 0, {Aimbridge…
-
Heirachy formula
I have a parent line with children underneath. I have a status column with red,yellow and green. Say I have 6 children lines under the parent line . I need for the status on the last entered children line to reflect on the parent line. If you close the Heirachy I will know what the last status was that was entered. Is…
-
Selecting only one checkbox
Is there a way to make only allow the user to select one checkbox? If they choose one, the others are unchecked? I have a survey with 5 options (1 checkbox for each). If the user selects #1 but then selects #2, I need #1 to uncheck.
-
Help with formula with multiple criteria
Looking for some help writing a formula multiple criteria... I want the formula to read the column "openings" and determine cost based on how many openings in the job. 11-20 openings = $225 / 21-25 openings = $250, etc... I tried building the formula with mutlitple IF statements, but i keep getting an unparceable error.…
-
Formula Within Next 30, 60, 90 days
Hello - Looking for help with a basic formula that will calculate how many projects end within a certain number of days. I have used: =COUNTIF({End Date}, <=TODAY(30)) I am not receiving an error message, but the result is much higher than the number is should be. Any help you can provide is appreciated! -Andrea