-
Networkdays Formula
Help! I've tried a 1000 different versions and nothing has worked quite right yet! We are counting workdays between a due date (date- due) and date of issue correction (date- corrected). Also, I don't want to receive the #invaliddata if my date- corrected cell is blank. I'm good with: =IFERROR(NETWORKDAYS([Date- Due]@row,…
-
What is wrong with my IF...AND stmt?
=IF(AND([# of Days Open]@row >= 22, Status@row = "Pending Review"), "Red", IF(AND([# of Days Open]@row <= 14, Status@row = "Pending Review"), "Green", IF(AND(Status@row = "Pending Review", AND([# of Days Open]@row >= 15, [# of Days Open]@row <= 21), "Yellow")))) In my calc above, it was working fine until I added the 3rd…
-
Formula for RYG for Project Schedule Status
We were able to create a formula for Green and Red status but have not figured out how we can automatically set the project status to YELLOW. Normally if an activity(s) are slipping that affects the critical path the project should be in a YELLOW state so a return to green plan can be worked on. So what I'm looking for is…
-
Adding prices in a column if there are multiple statuses identified
Hi Everyone, I have no training in formulas and am only self taught. I cannot seem to figure out how to create a code for this situation, thank you in advance for your help! I would like the formula to add up the dollar values of one column when there are certain statuses selected in a second column, and also is identified…
-
Multiple IFs then SUM
I have developed individual project sheets. In the project sheet I have multiple tasks. I want to populate number of hours I worked on each task, by summing the number of hours I worked on that project prior to a certain date. I keep all my hours worked on various projects in a work log which I am referencing from the…
-
Nested IF-AND-OR within the same cell...
Hi All, I am trying to automate a cell based on the status selected in 5 different cells (all within the same sheet) For Eg., First 5 columns has the following Statuses. Complete Incomplete In Progress Sick Dropout Cancelled Scheduled Conditions are Main status is 'Complete' when all 5 columns are 'Complete' Main Status is…
-
Is there a Column Formula I can use to always assign tasks to myself?
I'm trying to sync up my personal task list along with client task lists to all flow into one report, which means I need to assign everything in my personal task list to me in an Owner column. Is there a way I can automate that with a Column Formula?
-
Formulas & Filter Assistance for a To Do List
Hi, I have tried a few searches and haven't quite found what I need to perform the function within my smartsheet. Hoping some of the Formula wizards can help me out. I am using Smartsheet to manage my to do list. The filters are great but only make allowances for 1 or ALL conditions, I require 2. I am wanting to create a…
-
IF/AND cross-sheet formulas
Hi there, I'm getting error messages with my formulas and was hoping someone could help. I'm trying to create a formula with the logic below: IF [Lot Number]@row in my target sheet = Lot Number in the my inventory form AND [Status] in inventory is "Approved" THEN check a box in my target sheet. Whenever I try to reference…
-
Formula for weighting tasks on a scale of 1-5
I have a sheet that is a master list of all of my ongoing and upcoming projects. I have a multi-select column that has a list of tags for product type. I would like to have a column that looks at the product types and assigns a number to indicate complexity. For example: Product Type 1 = 1 (simple) Product Type 2 = 2…