-
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…
-
=IFERROR formula
Hi Within my project plan sheets I have 2 columns , On Time/Late and RAG. On Time / Late Column Formula =IFERROR(IF(AND([Original vs Current (days diff)]@row > 8, Status@row = "Complete", Milestones@row = "true"), "Late", IF(AND([Original vs Current (days diff)]@row <= 7, Status@row = "Complete", Milestones@row = "true"),…
-
Countifs calculating more than range
Hi All, =COUNTIFS([Execution Team]:[Execution Team], "NA ISG Specialty Event - AH Org", [Start Date]:[Start Date], DATE(2020, 8, 1) <= DATE(2020, 10, 31)) I am using this formula to gather number of events we're having internally. I did this per QTR and change dates, but noticed that it is counting ALL events that are less…