-
Counting Unique Data Only if Associated Column is Not Blank
Hello again! We really do research these things before we ask! ;) We are looking to count the unique Store Numbers for "P1 Complete Dates" and "P2 Complete Dates" in the Sheet's Summary Data, so we can make sure each store is only being counted once for each phase. The formula that we found and tried is only giving aโฆ
-
Manpower Counts by Date
Hi! I have a construction schedule with the following column names: task, start date, end date, duration, assigned to, manpower. The "assigned to" column is different subcontractors such as "sheet metal subcontractor", "piping subcontractor" etc. My schedule is about 1500 lines long with lots of concurrent activities. Myโฆ
-
Combining CONTAINS, with NOT(ISBLANK and NOT(CONTAINS
Hello Smartsheet Community! We have (3) columns: Country, Tracking, Project Status. We need to count the number of cells that contain "CAN" for Country, Tracking is "Not Blank", and Project Status does not contain the word "Complete". Below is what we attempted, but are unable to get a result: =COUNTIFS(Country:Country,โฆ
-
#REF on all my Sheets
Why am I getting this across all my sheets. It just recently started in the last week or so and everything referencing one sheet
-
evaluate if a cell date is weekend and convert its date to next weekday
Hi All, I am trying to add a number of days from a calculated cell to a date and deduce a new date (weekday). I am calculating the number of days based on allocation and adding that to the current date to get a new date. I need help to evaluate the result of function in current cell and increment the date to next weekday.โฆ
-
Health and Status roll up from task to child to parent
My roll-up formula in my parent row is working perfectly and captures the information from its primary children rows. =IF(COUNTIFS(CHILDREN(), "Red") > 0, "Red", IF(COUNTIFS(CHILDREN(), "Yellow") > 0, "Yellow", IF(COUNTIFS(CHILDREN(), "Green") = COUNT(CHILDREN()), "Green", IF(COUNTIFS(CHILDREN(), "Blue") =โฆ
-
SUMIFS with two condition in the same column
Hello, I am having trouble creating a formula to trigger if 2 conditions are met within the same column. I am trying to sum the PO amounts for each time โElectricalโ or โC Boxโ shows up in the CType column. Unfortunately, I am getting #UNPARSEABLE returned. This is the formulas I have tried so far: =SUMIFS({CType},โฆ
-
Count two different combinations of criteria.
This formula works for one combination of "HWMP" + "Notice Package Approval" =COUNTIFS({Regulations Development Range 5}, CONTAINS("Notice Package Approval", @cell), {Regulations Development Range 3}, "HWMP") I'm trying to expand it to count two combinations: "HWMP" + "Notice Package Approval" "HWMP" + "Pre-Comment Periodโฆ
-
Checkbox formula matching data from another sheet
I would like to create a formula to verify data from another sheet and check a box if true. Here are the details: This is sheet 1 where Contract Sent and Contract Received are checkboxes. Here is sheet 2 where I have Envelope Status and the matching column of Contract Contact Name. Is it possible to write a formula in theโฆ
-
Count between two columns if looking for non-blanks in one of them
Hi all. We have (2) columns: Tracking and Project/PO. We need to count all of the cells in "Tracking" that have a tracking number i.e. are NOT blank, but at the same time NOT counting any cells from a row that also contain the word "Lab" in "Project/PO" These are the two versions we have tried, based on other similarโฆ