-
Sum(Children()) and Sum(row:row) not totaling correctly
I created a sheet to itemize costs on furniture orders. I used a hierarchy so I could just use =sum(children()) to see the total costs of each project. While the first project totaled correctly, the second is coming up with an additional $2919.36. First I went back to ensure all of the figures are correct, and they are. I…
-
How to use the COUNTIF formula when you have an OR statement that looks at multiple columns
I am trying to come up with a formula that will calculate how many tasks I have that are either "At Risk", which is a checkbox (flag) column, or has red health, which is a symbol column. I need a formula that does not add the totals of those conditions. For example, if a task is both At Risk and red health, I want that to…
-
Receiving INCORRECT ARGUMENT SET when using an IFERROR
This is the error I'm receiving on my sheet summary page. Please note that the sheet is "set up" with columns and necessary formulas, there is just no information entered yet. Every time I open this sheet, I get the error above. To fix this problem, I just copy the formula, delete it, then re-paste it. This is after I…
-
Adding a Date require to IF statement
Hello, I'm looking for assistance in adding some criteria to this AVERAGEIF formula to make it so I am only averaging dates from this year. =AVERAGEIF({Completed - Department}, =[30 Day Post Release Quality Score - Segments]@row, {Completed - AQualityP30D}) There is no AVGIFS so I'm not sure how to appraoch this any…
-
Need to add 6 months and 3 months to a date
I have a date that other will populate, but I need to have two columns that calculated 3 months out from the date and 6 months out. I have tried several formulas on the forum and nothing is working. I am completely stumped. If I was in excel this would have been done in a minute.
-
COUNTIF referencing another sheet
I am needing to count the number of rows that are classified as rolling deadlines. The data I am trying to reference is in a separate sheet. This is the formula I currently have that is giving me the #UNPARSEABLE error. =COUNTIF({Proposal Tracker Range 1}[Deadline Type]:[Deadline Type], "Rolling Deadline") Please help me…
-
Fprmula to count date with 2023 as year
Hi im trying to add the week number only for projects with 2023 dates. the below only counts all week number but doesn’t distinguish between year. can you help =WEEKNUMBER([ACTUAL - Site Acceptance Completion Date]1)
-
Show Last Non-Blank Text Cell in Row
Hi Everyone, Hoping you can help because I'm stumped. In the 'Most Recent/Current Project' column pictured below I am trying to add a formula that will show the text within right most cell that is not blank. I've tried two methods that work in Excel, but the formulas don't seem to be usable in SmartSheet. In Excel, I've…
-
COUNTIF not returning correct amount of rows
hi i have a formula in my sheet summary that uses a countif formula to to count how many rows contain "Eng Ops" in my "Function" column. the formula puts out 31 as the answer but when i filter the sheet to show rows containing "Eng Ops" they're 35 rows. =COUNTIFS(Function:Function, CONTAINS("Eng Ops", @cell))
-
How do I count if someone attended?
Hey! I've been messing with this formula for a bit, and I'm kinda stumped. I'm trying to count how many people have attended a course on a certain day. So, if "Attended" is checked on 1/23, then that should count as one person attending. Columns Referenced: Attended = Check Date = Date format…
