-
Counting the number of Checked Boxes
I have a column name Phase I and I want to count all the checked boxes from row 1 through row 20. I am using the following formula: =COUNTIFS([Phase I]1:[Phase I]20, =1) What I get is #Boolean Expected? Any Suggestions? Regards
-
Can I create a Column Formula which automatically applies text in a Parent Row to the Child Rows?
When rows move into my sheet, I use them as parent rows for my projects. I want to have a column formula which automatically pulls in data from the parent row to its child rows. I've tried putting =PARENT() into a child row but it makes all cells in that column empty when I convert it to a Column Formula. Any assistance…
-
Calculating Days Remaining and Past Due
Hello everyone, I am trying to calculate the days remaining and days past due for each row, however, I want it to stop count if the status is closed. As you can see we have a "Days Remaining/Days Past Due" column and those closed (the grayed out rows) still calculate a number which is what I do not want. I tried doing it…
-
Harvey Ball Formula based on multiple criteria
Hi, I'm looking for a formula to populate the Harvey Ball color based on the Status of the project For example: In Progress = Green In Progress and Delayed = Yellow Not Started = Red Complete = Blue Cancelled = Blue On Hold = Yellow My formula is =IF(Status@row = "In Progress", "Green", IF(Status@row = "In Progress and…
-
Individual Cell (Not Row or Column) Conditional Formatting
Greetings, I am new to Smartsheet and am looking to change conditional formatting on individual cells (NOT the whole row or column). As I track products being produced in our plant, I want to be able to have the individual cells for the Start Date column turn green once the date is 'in the past'. Here is an example of what…
-
adding multiple values together
Hi, i am trying to build a table where i have to add multiple criteria such as "Not Started", "In Progress", "On-Hold", if i use this formula =COUNTIFS({IRM SOW #13 - RAID Log Range 3}, [ARIaDd Type]@row, {IRM SOW #13 - RAID Log Range 1}, "In Progress") it works fine but if i add the search in for the other criteria is…
-
Help with conditional ongoing merging of multiple spreadsheets
I have 3 sheets. 2 are kept up to date with new activities by different group members. the third I want to capture new entries into the other 2 sheets when certain conditions are met. Is there a way to write a lookup to search for new entries and if found add to third sheet with accompanying information? The data on the…
-
Date based Priority dropdown formula
I have a target completion date column. If this date is within 14 days, I would like the "exclamation mark" to automatically populate. Is there a formula for this?
-
Nesting multiple functions
Hello I'm struggling to nest 3 IF functions extracted from 2 separate columns into 1 cell. The one column is a checkbox(ENM INITIATED) and the other is a drop down(JOB STATUS: COMPLETE, WIP, ON HOLD and NOT STARTED). Also the column in which the 2 functions are nested is a symbol type? These formulae all work individually…
-
Disregarding N/A in Formula
Hi, I've been using this formula: =IF(SUM(VALUE(RIGHT([Overall Summary Cost]@row, 1)), VALUE(RIGHT([Overall Summary Schedule]@row, 1)), VALUE(RIGHT([Overall Summary Risk]@row, 1))) < 5, "Blue", IF(SUM(VALUE(RIGHT([Overall Summary Cost]@row, 1)), VALUE(RIGHT([Overall Summary Schedule]@row, 1)), VALUE(RIGHT([Overall Summary…