-
Counting Checkboxes in a row and then showing the average %
I am trying to find the average of checkboxes in a row. At row: "Clear pads as needed..." I want the % to add up as each box is checked. What is the formula? Appreciate the help.
-
SUMIF formula when cell contains multiple collaborators
I currently have a formula that will sum up the "Hours Used" from the "proposed hours needed" field based on which intern is assigned. =SUMIF(Intern:Intern, "Michelle", [Proposed Hours Needed]:[Proposed Hours Needed]) However, when BOTH interns are assigned, it doesn't acknowledge the hours - how can I update my formula to…
-
Count IF on System-Generated Column
Is there any reason why this formula would be totaling a different number than what I am seeing here? I am counting 17, however, the formula keeps returning 30. I am counting 17, however, the formula keeps returning 30.
-
Use SUMIFs and ISDATE to sum based on dates within the past week
Hello, I'm attempting to use SUMIFs to sum one column based on whether another column has dates within the past 7 days. However, my current formula is unpareseable. All help is appreciated! =SUMIFS([No if Sites]:[No of Sites], [Payments Closed Won Date]:[Payments Closed Won Date], ISDATE(TODAY()-7)) I have seen posted…
-
Apostrophe added to formula that is pushed from Zapier
We’re using a sheet for ticket tracking. Issues come in via a form, manual entry, or the Gmail Add-on. We’re using hierarchies to track To Dos as tasks. I use a simple formula to tell me if a row is a task or a parent. =COUNT(ANCESTORS()) I use the value for formatting and for accurate issue counts as I only want to count…
-
COUNTIF(CHILDREN() Formula Assistance
The following works for my sheet but I'm unsure how to write it so that if there are no child rows, it will say "No Submission Received". =IF(COUNTIF(CHILDREN(), OR(@cell = "Facilities Readiness", @cell = "Workspace Navigation and Signage")) = 2, "Final Approved", "Partially Approved") Appreciate any assistance! Thanks!
-
Counting Number of Date Instances
Hello, I'm trying to create a formula to count the number of instances of a particular date - but I can't get a response out of the forumla - it either comes back as unparseable, or with a 0 count (even though that's the wrong count). I've tried a few variations: =COUNTIF(DATE:DATE,06/10/2020)…
-
Seemingly Simple "IF" Statement
I keep getting an "#unparseable" on what I think is a simple IF statement. Can someone help me out? Here's the statement ---> =IF([Coffee Chat Completed]1 = 0, "Yes, Follow-up Needed", ["No, Follow-up Not Needed"]) It's Monday and I think I need more coffee. Thanks, Smartsheet Community!
-
Help with formula: average productivity in different production lines.
See picture. I`m trying to find the formula too help me sort out the average productivity in different productionlines. Can somebody help me with the right formula? I need to find the averiage "produktivitet" sorted by "Linje 1, 2 etc" and sorted by date. Referenced from the sheet below to another sheet.. :)
-
Reference the contents of an entire column and return a RYG value
Hi, I am trying to return a RED value (traffic light) to a specific cell where any cell in the column "Risk Flag" has been checked. I can get it to return a Red value where a single specified cell in the Risk Flag column is flagged - as follows: =IF([Risk Flag]2 = "True", "Red") I need it to return a Red value where any…