-
Formula to update a value automatically
I have 5 rows. The value for each can be low, medium, or high. If the majority of the rows is one of the values then I want row 6 to return that value. But if any of the rows are high Row 6 value should be high. Example: Row1--Medium, Row2--High, Row3--Medium, Row4--Low, Row5--Low., Since Row2 is High Row 6 value is High…
-
Using COUNTIF to count multiple text values in the same column/range
Hey everyone, I'm having a bit of trouble and have browsed through many of the discussions regarding COUNTIF for multiple criteria. I've tried using COUNTIFS, regular COUNTIF and a combination of those two with CONTAINS as well as HAS. Essentially I am trying to count when criminal charges "Fraud" and "Trade Secrets" both…
-
Formula for status color
Hello, I am looking for the right formula to make the Status color change. My goal is to have the color change based on the days since updated. So the status will be green 0-179 days. Then Yellow when the days since updated is 180+ days, and turn Red if it's 360+ days.
-
30/60/90
Is there a formula quick guide on how to create a 30/60/90 day outlook in a dashboard of upcoming projects finishing and starting? I am banging my head trying to figure it out. Thanks in advance.
-
COUNTIFS and Date Range
Hi! I want to be able to create a formula that says: COUNTIFS Employee Status equals "Active" AND Employee Type Equals "Full Time", but falls within the month of March (or any month after that) Please help! Thanks!
-
Calculating % with a minimum value
I'm looking for a formula that calculates the percentage of two columns, but shows a minimum percentage of 50% if the calculation is less than that. Is this possible to do in one column, or do I need to have one column with the percentage, and the next with an IF function? My knowledge of functions is limited so thanks in…
-
VLOOKUP Reference Vacation Calendar to Update Approver via Automated Workflow
Hi, I have an employee Vacation Planner sheet with a status column/formula that indicates whether an individual is currently on "PTO" based on today's date and whether it falls in the range of their vacation's start and end date. In a separate Smartsheet, we will be managing service tickets and certain types of requests…
-
Master Roll Up that Auto references a new sheet created from a template
Hello SS Community, I am creating a master roll up sheet that counts how many "at risk" tasks a team member has across several projects. We have a Project template that each job gets created from. My wish is to have the master roll up automatically reference the "health" and "assigned to" columns each time a new project is…
-
Answer if box is checked
=IF([Estimate Qualifies]@row, 1, [Total Contract Revenue]@row * 0.005, 0) how can I make this work?
-
Subtracting Dates between 2 cells - #INVALID OPERATION
I am using the below formula to subtract 2 cells that contain dates. I have determined that the error is the the operation on the subtraction of the row date from a fixed / start date. =IF(AND([Column18]8 = "Day 1", $[Column22]$6 - [Column14]8 > 0), 1, 0) see pic