-
Countifs across multiple columns
Hi I want to count how many times Name=xx, has Green/Yellow/red balls across 7 columns =COUNTIFS({C-test Creation House applications Range 5}; [Column4]13; {C-test Creation House applications Range 6}; [Column5]12) (the range 5 is the reviewer column, and the range 6 are the 7 columns) It works if I only choose 1 column,…
-
Traffic Light Formula Based on Date and % Complete
Hello, I am trying to create a health status formula using the traffic light: Red, Yellow, Green Blue symbols. I would like the status to update based on the Deadline as well as the % Complete. The second set of conditions within the formula will not return a result. Here is the formula: =IF([% Complete]@row = 1, "Blue",…
-
Comparisons of dates(Committed date,New Committed date & Actual Completion Date)
Hello I have 3 dates column in smart sheet i.e Committed date,New Committed date & Actual Completion Date I need to compare these dates like if Commited date is> New committed date then i should get some color & the same way if committed date>actual completion date then i should get color & the same if New committed date…
-
Multi select checkbox count checked items
I have a multi-select checkbox that I am trying to count checked items in the cell and total in another cell In the column invest strategy capability I want to count items checked in the cell with the first arrow and put the total in the check mark under invest total. Same for the second arrow. I have seen the Countif and…
-
Update health indicator formula for tasks that are not due to start
Hello, I'm relatively new to Smartsheet and found the following formula on this discussion board (I can't find original post). I need to update this formula to show "green" for tasks that are not scheduled to start yet, rather than blank. The columns in play are Planned Start Date, Planned End Date and % Complete If task…
-
Incomplete Tasks Count Multiple Criteria
I am trying to account for the number of incomplete tasks for Symbol column types. For example, our 'On Target" column uses the RYG Balls, and i am trying to pull back the number of incomplete tasks based on their color (red, green or yellow). This is the formula i have tried to use based on recommendations from this post…
-
Formulas and Newly Added Rows
Hi, Our case application requires a lot of movement of rows between sheets, and I am having an issue with Formulas not automatically applying to newly added rows which necessitates going into the sheets and manually clicking and dragging the formulas to newly added rows from the rows above (time consuming with multiple…
-
Percentage of certain type of hours submitted
Hi, I'm looking to get a percentage of the total number of hours submitted for a certain category from a drop down list within a time frame. In column A is the date of the submission, column B is the category (e.g. Internal Meetings, HR, General Admin etc.) and Column C is the amount of hours submitted. I would like to be…
-
IF Formula Help
Hello, I am trying to write a formula that checks the box when a condition is met. In this case, when the Job Status is marked as As-Built Submitted I want the check box to automatically be marked. Please note the Job Status column is a drop down: Thanks!
-
Need assistance with a formula
Hello, I am using the below formula to count the number of rows where 140R was checked previous month. This formula was working perfectly fine until this month when the year changed. How can I fix this formula where previous month should be looked at December 2019 for January 2020, but it should look at January 2020 in…