-
RYGB and Check Box
Hello everyone, I am a new Smartsheet user and having problems with a function. When the "Blue" ball is selected in the Health column, I would to automatically have the check box in the Complete column checked. Embarrassed to ask such a simple question. =IF(AND(Health@row="Blue",) (Complete@row=1,1)) Greatly appreciate the…
-
Identifying specific combinations from a multi-select field
Good morning, fellow Smartsheeters. I have a master roadmap sheet that we use to populate numerous dashboards and reports. One of the columns on this roadmap is Project Type. It is a multi select drop down with the following values: Revenue Opportunity, Revenue Loss Avoidance, Risk Compliance & Cost Savings The…
-
Formula for connecting Checkbox columns with Health column
I am looking to connect both Checkbox columns with the Health column. These are the formulas I am looking for. If Nothing is checked off, Health = Red If SO Submitted = checked, Health = Yellow If Done = checked, Health = Green
-
At Risk Column - How do I count this in my Summary Sheet
Hi Smartsheet Community, I am in Summary Sheet for my Project Grid. I want to count the number of "At Risks" that are Flagged. I have tried =COUNTIF({At Risk}, "Criterion"). I have tried "Flagged", "Flag", "On" and "True", but none of these are working. Can someone help me with this please? I'm sure it's something simple.…
-
Formula most urgent topics with RYG, date
Hallo, I want to combine the following columns with a formula in the sheet summary: RYG, date of receipt, comment and hotel The sheet summary should show "hotel name" and "comment" if RYG = "red" and (the earliest date of receipt as most important aso.) Hope you can help again ;-)
-
COUNTIFS/SUMIFS for multiple column criterias
Hi, I have been trying to find the answer to my question on other Smartsheet community posts but no luck so far hence this question - how do I SUMIF/COUNTIF when there are multiple conditions to look at? Basically, I am trying to find all instances of the value "2 - OPPORTUNITY FOR IMPROVEMENT" in a column when the Site…
-
Project Health Calculation
Please can you assist. I am currently using the SS Standard template Schedule Health Formula : Project Heath Formula =IF([Schedule Delta (%)]@row > 0.1, "Red", IF([Schedule Delta (%)]@row > 0, "Yellow", "Green")) My issue - Milestones which should not be are showing green because the Duration is Zero (see schedule formulas…
-
How do I do a row request?
I am trying to create groups of tasks that can be used by using a filter. Unfortunately I need to be able to know the row# of all added rows in order to have the new rows visible for each group. I want to have a cell that marks the start of a section and one that marks the end. The ones between need to be filled with the…
-
COUNTIFS Referencing another sheet and pulling data from a specific time period
Hello, I am trying to create a formula that will pull the number of times an entry was submitted for a specific location from another sheet, but I want to set the date it should start counting from and no end date. The data that the formula will compute I will then use as a reference cell for a chart I created on a…
-
Help w/ COUNTIFS and ISBLANK and NOT ISBLANK
Hi team - I have 2 columns (Seat and Open Req) that I need to count: When Seat = Filled and Open Req is not blank When Seat = Filled and Open Req is blank I'm struggling with the COUNTIFS sequence to get this to work. Any help would be greatly appreciated.
