-
Parent/Children Flag Formula
Hi all, I'm trying to create a formula that will flag a child row if a certain date is within a # of number of days, but I'd also like it to flag the parent row if any of the children row are flagged. I am currently using these two formulas: for the parent row - =IF(COUNTIF(CHILDREN(), =1) > 0, 1, 0) . . . and for the…
-
If checked subtract using a date, if unchecked subtract using another date
Good afternoon, I am trying to create a day counter that will be counting until another date is filled. I thought nesting if formula's would work, but so far I am not successfully creating the correct formula. A screenshot below will hopefully help and here is the formula I wrote that is giving me the "Incorrect Argument…
-
Automated RYG Based on % Complete Formula Help
Hi, I'm trying to automate the RYG colored balls so they automatically change colors based on the percent complete entered. I watched a video, read through the suggestions from the community, and was unable to come up with a formula that worked correctly. Can you please help me identify the error in my formula? When I…
-
"IF" formula using dates and check boxes
I am looking to set up a count to see how many people are scheduled for an appointment verses how many have come in. I have an appointment date column and a check box that is clicked when someone comes in. I want this to be a summary formula not a cell. Could someone help? What I messed around with was…
-
Sumif matches criteria from multi select dropdown
Please help, i want to sum the Time Required in case the Week Number column has 1 and update Status is Monthly. I used this below formula but its not working. SUMIFS([Time Required (Hrs.)]2:[Time Required (Hrs.)]6, [Week Number]2:[Week Number]6, HAS([Week Number]2:[Week Number]6, "1"), [Update Status]2:[Update Status]6,…
-
Help with a formula
Hi! I'm having trouble figuring out a formula for the following situation. I have a column called "date applied". I want to know how many candidates applied per day. I also would like to add to that more filters I.E. location. Meaning I want to know how many candidates applied PER DAY PER LOCATION. Similarly I have a…
-
Levels formula
Hi all I am new to smart sheets, and I was after the formula for Levels and cross-referencing % to give a result. I have the following code in levels, but I need this to be more intelligent. =COUNT(ANCESTORS()) This returns the Uppermost parent as 0, Next level as 1, last level as 2. Is there a way of looking at the %…
-
Help with if max collect formula
Hello, Sorry I know there are already questions on this but I'm not getting it. I have a column [Users] of duplicate users, and a second column with unique numbers [Row ID] In a third column I am trying to get "Ignore" or "Select" based on the highest number per user So in the example above the PCUK832 should say ignore…
-
Cell Linking
Is there any way to stop a cell link from updating at once it has been populated? I am using the INDEX/MATCH formulas to assign a person to a task based off of a state assignment list. Once the task is completed, I do not want that person's name to change, even if the state assignment changes in the future. Any help is…
-
How to use COUNTIFS with HAS and match 2 Columns while counting multiple selections in dropdown
How to use COUNTIFS with HAS and match 2 Columns while counting multiple selections in multi select dropdown ? Solving for: How many "Devon's Corner" Leads do we have by Location Type - "Bar" or "Brewery".. If any or both of these options are selected, they should be counted as 1 =COUNTIFS({Brand Type 1}, "Devon's Corner",…