-
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:…
-
Convert months to years
Hi, I have a sheet that currently takes a start date and adds a number of years from another column to create an end date: =IF(OR(ISBLANK([Contract Start Date]60)), "", IF(OR(ISBLANK([Contract Period (Years)]60)), "", DATE(YEAR([Contract Start Date]60) + [Contract Period (Years)]60, MONTH([Contract Start Date]60 - 1),…
-
Dashboard Chart Displaying Currency for Viewer
Hi Smartsheet community, As an Admin, I setup a dashboard with a chart showing data with $ signs. A viewer sees the same dashboard chart with US$ signs. Is there a way for the viewer to see only $? Thanks for any suggestions! Dee
-
Return a cell value based on multiple variables
I am having trouble working out a formula to put into a cell. I want the cell to change, based on the value in a cell. If the 'status' cell in my document is marked as 'complete', I want to change a cell at the end of the document to 'Complete'. If the status cell is marked with anything else other than 'Complete', I want…
