-
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…
-
Nested Ifs checking for different conditions
Hello, I am trying to add an additional argument to a formula to check if a cell called "Awaiting Response" is not blank, and if so, change a RYG cell to yellow instead of red, but I am getting either #UNPARSABLE or #INCORRECT ARGUMENT SET. The conditions are all based on when the last response was to a ticket, with more…
-
At Risk Flag Formula Help
Hello, I currently am using the below formula in the At Risk column which works just fine. If baseline due date is 3 days out and status is not checked off as complete as well as % complete is not 100%, flag as at risk. =IF(AND([Baseline Due Date]@row <= TODAY(3), [Baseline Due Date]@row >= TODAY(), Status@row <> "Yes", [%…
-
How to apply the same 5 different criteria's in conditional formatting for multiple columns quicker
Hi, I have set up a smartsheet to measure the performance of staff. So 0 = not evident 1= somewhat evident 2 = Evident 3= Above Expected Once the performance of a staff is observed, the observer keys in either, 0, 1, 2 or 3 etc under the persons name. There are over 30 different criteria's to look at. So Mary might be a 1…