-
Nested IF Statement
I'm fairly new to Smartsheet and I'm trying to calculate a planned budget based on an "Assigned to" column. I'm getting unparseable, so I'm missing something. Here is what I'm trying to build if someone might help me solve the issue... =IF([Assigned To]@row = "Bob Dole", [Planned Hr]@row * 175), IF([Assigned To]@row = "Abe…
-
Formula
Hello, Can someone help convert this excel formula to SS? =IF([DAY COUNTER]1 = "1", =TODAY(), IF([DAY COUNTER]1 = "2", =TODAY() + 1, IF([DAY COUNTER]1 = "3", =TODAY() + 2, [DAY COUNTER]1))) Expected result is to determine that 1 = current date, 2 = current date+1, 3= current date+2 I'm not sure if I'm explaining it…
-
Average of project completion for current year
I'm trying to average the "%" column based on rows that are only in quarter 1 (Quarter Identifier = 1), and have a completion date that is the current year. I'm trying to make this sheet roll over year-after-year and am trying to stay away from specifying "2019". The formula I have currently is: =AVG(COLLECT([%]:[%],…
-
Count of Completed Tasks by Month across multiple sheets
I am trying to get a count of completed tasks by a team by month across multiple sheets. I've created this formula in the sheet summary: =COUNTIFS(Status:Status, "Complete", [Team Assignment]:[Team Assignment], "Lean"). If I'm trying to get a completed count of tasks for the month of September, how could I get that count?…
-
Importing\Uploading Information
I know you can create a sheet by importing a document into SmartSheet and having it auto-create around the information; however, how do you continue this? IE You take a sheet from Excel, that will continue to be used, and import it into SmartSheet, then you want to update the information in the SS later by just…
-
Trouble with COLLECT in INDEX/MATCH
I'm trying to troubleshoot an INDEX/MATCH formula that contains a COLLECT statement which is supposed to limit what cells are being used for the MATCH. I am referencing a project schedule, looking for the "next deliverable" - we have a column called "Function" in which the schedule tasks can be defined as such. (See…
-
Countif range from multi select contains (value) under each parent from another sheet
I need a cross reference formula using countif a specific value in a multi select column is under a parent from another sheet.
-
COUNT IF formula
Hello, I've read through a couple of different examples, but I am not having any luck. I am looking to have the # Assets count total displayed in the highlighted parent row/cell based on the following criteria. If # assets cell below the parent is greater than 0 for the total count to display.
-
Roundup causing error on reports
Hello, I added the new roundup formula to my sheet and this cause all of my reports that reference this column to show up as #unparseable only on the report. This shows as a value on the main sheet. To make this worse any other formula on this sheet shows up as #blocked until this is removed
-
SUMIFS to COLLECT DESCENDANTS
I am trying to rewrite some formulas in a large sheet due to the sheet crashing regularly. It is my opinion that the sheer mass of SUMIFS within this sheet is causing it. Here is my current formula: =SUMIFS($Actual:$Actual, $[Job Number]:$[Job Number], =$[Job Number]@row, $Department:$Department, ="Design",…