-
Formula Error
Good afternoon, I dont know what I am doing wrong, but every tikme I try this formula I get this erros =SUM([Budget Unload]@row, [Budgeted Python Per Piece]@row, [Budgeted Fit Up]@row, [Budgeted Weld]@row, [Budgeted Paint]@row, [Budgeted Load]@row) * 0.1)/60 Anybody know where I am not doing the syntax correctly?
-
Multiple IF Formulas - cannot figure out why it's producing a "0"
Hey all - I'm working on a formula that built as an IF formula. It has multiple "IF" statements, and I'm stumped as to why it's producing a zero (although it's likely because there are too many "IF" formulas) and what to use in leu of this formula. I want the formula to put out an abbreviation based off the team name -…
-
Ways to see total duration in months
I'm looking for a way to see the total duration of a project in months. I've found the NETDAYS formula, but the unit is days, not months. Is there a way around this?
-
Conditional formatting not working with certain portion of a formula
Hello all. I have a date column that is populated via a formula, referencing other cells within the same sheet (both date and drop downs). Before I changed this column to populate via a formula, I had simple conditional formatting based on if date was in the past (red) or in the future (green). Since I added the formula,…
-
Help with Stacked IFs for Color Balls
=IF(Status@row="Complete","Blue",IF((AND[Actual Start Date]@row=[Start Date]@row,Status@row="In Progress"),"Green",IF(AND([Actual Start Date]@row<>[Start Date]@row,Status@row="In Progress"),"Yellow",IF(AND([Actual Start Date]@row<>[Start Date]@row,Status@row<>"In Progress"),"Red")))) Tired eyes, I know I'm missing…
-
Reports
Hi, I have a report that updates from +-500 sheets from a subfolder in a workspace. If we add a sheet, it doesn't automatically update the report with the new sheet, in the same subfolder. Is there a workaround?
-
vlookup error
I am trying to write my first vlookup formula in Smartsheet and running into an error I can't resolve. This is the sheet that I am writing the formula in: This is the formula I've written: And this is the lookup_table am referencing: The Detail Status that is my search_value is in the first column of my lookup_table. My…
-
COUNTIFS Fomula
I created a COUNTIFS formula in Excel which would count the values "Expired" and "Overdue" and add the total's together. Excel Formula: =SUM((COUNTIFS(C:C, "CO-CURRIC-COI",J:J,"Expired")),(COUNTIFS(C:C, "CO-CURRIC-COI",J:J,"Overdue"))) When trying to emulate it in Smartsheet, I get a #unparseable error. Not sure what I am…
-
1/3/2021 to January 2021 formula
I did see this on another post but it was referencing dates in two different cells. This is that formula: =INDEX([Text Column]:[Text Column], MATCH(MONTH(IF(ISDATE([Report Date]@row), [Report Date]@row, [Date Received]@row)), [Number Column]:[Number Column], 0)) + " " + YEAR(IF(ISDATE([Report Date]@row), [Report Date]@row,…
-
Countif formula; exclude completed status
Hello, I currently have the formula to count how many priority levels each team has but would like to exclude the completed items from the count. Is there an additional piece of the formula that I need to include?