-
Overall Project Health Formula
Hiya folks, We want one field to show Overall Project Health. Ideally, we would figure out how to average the colors and/or tasks past due to return RYBG for the overall projects (about ~230) so that we can report it on a Dashboard. Any ideas on formula would be so appreciated. Circular reference error formula in OPH row:…
-
IF AND OR Formula *almost* works correctly but one part!
Hiya folks- all arguments work correctly except turning Health the color Yellow when Recommended Due Date is within 3 days of current date and status is not Complete. Here is what I need to accomplish: IF [Status] is"Complete" or "Cancelled/NA" then [Health] ="Blue" IF [Recommended DueDate] <= TODAY and [status] <>…
-
How do you make IF and IF(AND statements work together
I am trying to populate a cell based on multiple date criteria. I am currently trying to use the below formula but I am getting an unparseable error =IF([Date Submitted]@row > DATE(2024, 9, 30), 25, ""), IF(AND([Date Submitted]@row > DATE(2023, 9, 30), [Date Submitted]@row < DATE(2024, 10, 1)), 24, "")
-
Formula
Hi all, I am trying to combine the following two formulas, only one works at a time. =IF([Variance (Target End date)]@row = 0, "Green", IF([Variance (Target End date)]@row <= -4, "Red", IF(OR([Variance (Target End date)]@row = -1, [Variance (Target End date)]@row = -2, [Variance (Target End date)]@row = -3), "Yellow",…
-
Please could someone kindly help me with this INDEX/MATCH/IF /AND Formula
Hello There Smartsheet Community Please could you kindly point me in the right direction with my formula? Sheet 1 Contains the following sheet references "Status" = Jira Status "MMP" = MMP I need to update the value of "Validation NL" based upon the following criteria: If "MMP" in sheet 1 matches "Req ID" in sheet 2 and…
-
If statements with <>, blanks, and errors
Need assistance putting all my "if conditions" into a single formula if possible
-
Nesting IF/OR Statement(s)
I'd like to combine multiple IF/OR statements so when I update my status column another column will auto update: When Status is Complete or Received list Full, if not, list Empty; when Status is In Process or Quoted list Quarter, if not, list Empty; when Status is Dispatched or Ordered list Half, if not, list Empty. Is…
-
I need help with formulas
I am working on formulas to get approvals in one of my sheets - But there are more than 2 options and I'm finding it a bit confusing… IF both directors APPROVE = Trade Off Accepted IF one director APPROVES and the other one is PENDING = Pending Acceptance (Would I need two of these?) IF both directors REJECT = Trade Off…
-
Automated risk rating
Hi All, I am building a risks log and I am getting stuck building 'if and' statements to automate the rating. I have a drop-down column for Likelihood and a drop-down column for Impact, and based on these two fields, it would be great if the rating column showed Low, Medium, High, or Very High according to the matrix…
-
Nested IF / AND Statements
I'm trying to put together formulas that will allow me to report forecasted labor across the months a project is active. I have all the formulas working individually but can't figure out how to group them into a singular formula. For example: Project Start: 6/17/24 Project End: 8/21/24 Forecast Cost: $10,000 The way I…