-
Adding formula to existing formula for status change
Hi everyone, I currently have a formula in my status column that auto-update depends on the percentage completion. Anything that is 0 is Not Started, and greater than 0% and less than 100% is Green (G), and anything that is 100% is Complete (blue). I want to add 2 more actions in the formula. If Finish Date is in the past,…
-
How do I use conditional formatting to highlight upcoming dates that do not match?
For example, I am using cell linking to pull in two different large pieces of data from two separate sheets. What I'm trying to resolve is how to flag column 3 date if it does not match column 2 date. I want to highlight the dates that don't match so we can resolve as to "why", internally. Thank you for your help with this…
-
Insert Formula within Workday "num_days" string
Hey, This may be super simple & this feature is available in excel, so I think i am just missing something in front of the "-1" for Smartsheet to pick up a formula. I am trying to calculate the day for a "test" shipment to arrive, based on 3 factors - 1. workday (with holidays), 2. Scheduled delivery date of devices, and #…
-
How Do I Count the Number of Occurrences of Text Across Columns?
I am trying to count the number of instances that certain text occurs across columns in a sheet. How do I count the number of "F"s, and "P"s across these columns.
-
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…
