-
IF formula
I want "In progress" to display if the check # field is blank or CCC Approved field is Yes, otherwise I want "Complete" to display. I've tried this formula but the syntax is wrong. =IF(ISBLANK([Check #]1), "In Progress", IF([CCC Approved?]1=YES, "In Progress", "Complete"))
-
#Unparseable Error When attempting to use IF function
Hello Everyone, I am trying to write an IF function to automatically change the value of a certain cell for certain conditions. For some reason I keep getting the #Unparseable error when I type out this formula. =IF((NETDAYS([Date Need By] 6, Today())) < 3, [At Risk], [In Progress]) I have attached a screenshot of the…
-
Help with formula if cell is blank
I'm using the following formula to piece together a date in a text/number cell: =IF(MONTH([Sale Date Form]@row) < 10, "0") + MONTH([Sale Date Form]@row) + "-" + IF(DAY([Sale Date Form]@row) < 10, "0") + DAY([Sale Date Form]@row) + "-" + YEAR([Sale Date Form]@row) It's working great, unless the "Sale Date Form" cell is…
-
COUNTIFS Multiple Criteria and Checkbox - #INCORRECT ARGUMENT SET
I am having #INCORRECT ARGUMENT SET error message with this COUNTIFS. Please help. I am trying to Count Client Name column if both criteria are met. 1) Client Experience Manager = "value" 2) Terminated checkbox not CHECKED =COUNTIFS({Client Name}, {Client Experience Manager}, "Joe Smith", {Terminated Checkbox}, 0) Any help…
-
At Risk Report with parent and only some select rows
Can someone please assist with reporting at risk line items? I have parent/child hierarchy and want to only report those parents that are over budget and only the line items under that parent that have fees greater than 0.
-
Countif when counting cells in other sheet between 2 values
Hi , I am struggling a bit with using Countif to return a value from another sheet. A column contains numbers, I want to return number of cells that are for example >5<=10, greater than 5 but less than or equal to 10. For example =COUNTIF({Other Sheet Range 2}, >5 <= 10) . Its does not seem to be working correctly as it…
-
Sum of values across Arrays/Lists
Hi there, I have a column that shows a set of values like this: COLUMN A Row 1 20:40:0:0:20:0 Row 2 2:4:0:0:0:4 Row 3 . 0:0:0:0:0:0 etc. Each row represents a project task. The value represents the number of employees needed for the task across 6 different employee types/categories (categories separated by ":"). I need a…
-
Formula Improvement
Hello! I am trying to write a formula to count whether a group is active or inactive and how many groups are active. There are a couple conditions though, column1: the cell must not be blank (if it blank, it should not count), column2 **is a dropdown menu with three choices** : the cell must either be blank or contain…
-
Formula to track % complete of a fabircation component in a row
Good evening, I will try and explain this without messing up * We are using smartsheet to track fabrication of product * each row is an item we fabricate * each item has a budgeted amount of time per task designated in a column * they are python, fit up , weld, unload, and admin * the sum of alloted time is *…
-
Using Collect() Function to Summarize Data by Project and Date
I have two sheets, one where I had a form that lets people input safety scores a row at a time for a given construction job site and another where I'm looking to summarize all the safety scores for a particular job site overall, today, this week, etc. I can get the overall safety score for a particular job site:…
