-
RGYB Automation
I'm having issues with the following formula and I'm not sure why. Task Formula below: =IF(ISBLANK([Start Date]@row), "Blue", IF([Start Date]@row >= TODAY(), "Blue", IF(AND([At Risk]@row = 1, [End Date]@row <= TODAY()), "Red", IF(AND([End Date]@row <= TODAY(3), [% Complete]@row < 0.75), "Yellow", IF(AND([Start Date]@row <=…
-
Formula for Priority Cell
Hello All: I am having a difficult time creating a formula that will give me Priority. Below are my rules for Priority Status. Thanks Urgency High If Impact High and Urgency High, then Priority is 1 If Impact Med and Urgency High, then Priority 2 If Impact Low and Urgency High, then Priority 3 Urgency Med If Impact High…
-
CountIf and Exclude Status
Hello! I am trying to count the number of requests types and exclude certain statuses. The current formula is: =COUNTIF({Request Tracker Range 4 - Request Type}, Category13). I want to display the current number of Client or Internal requests and omit Completed or Declined. Any suggestions are appreciated!
-
Automatocally changing due dates and status on recurring tasks (Monthly, weekly, etc)
How do I make a row update the due date for a monthly, weekly, and/or quarterly recurring task? I would like it to automatically change the due date to one month, one week, or three months in the future and change the status back to Not Started once a recurring task is marked Complete. I need to be able to do this at the…
-
Index match returns a wrong value
Anyone able to help with an Index/match formula that returns a wrong value? We've a formula that is returning a wrong value. I believe the formula is correct (it's the same way I write it in .xls). We are referencing another Smartsheet in the formula. I understand if I was getting an error (#invalid value, #No match), but…
-
Using IF with RYG formula
Hello I am trying to build a formula where: * If the "Date Entered" column is within 60 days, the "Req Health" stays Green * If it is 90 days or more, Req Health turns Yellow (I got this formula figured out) * 125 days or more, Req health turns Red. Sheet…
-
Rolling 2 week task count
Hello, I am trying to do a cross sheet formula that counts the number of tasks that are not complete and have a due date in the next 14 days for a specific department. I hope I am close but it is coming back as unparseable. Could someone please review and tell me where my mistake is? Please find my formula below.…
-
Countifs with Distinct?
I have two columns, Column A and Column B. How can I check Column A for a condition, and then count all the distinct corresponding values in Column B for which that condition is met? Is there an easy way to do this with Countif / Countifs and Distinct? Thanks!
-
IF or IF AND Formula conditions DATE
Dear, I appreciate your help. I need to create a formula that changes the status column depending on the following conditions. (The image in the example table has reference TODAY = August 28, 2019) 1) If the Balance column is equal to 0 (Green) 2) If the Balance column is less than 0 (Yellow) 3) If the Balance column is…
-
Multiplying cells from different sheets
Sheet 1: Work Scheduled (number of work units scheduled in a given month) Sheet 2: Budgeted Cost of Work Scheduled (to determine the total cost of the work scheduled in a given month) I would like to multiply a cell from Sheet 2 with the corresponding cell from Sheet 1 and then be able to copy/paste the formula so that it…