-
How do I use the SUMIF formula using data from another sheet to add the results within a date range?
My formula is below and is returning "INCORRECT ARGUMENT". =SUMIF({Weekly Production Orders Range 2}, AND(ISBLANK(@cell) = false, AND(@cell >= DATE(2020, 1, 12), @cell <= DATE(2020, 1, 18))), [Week 1]2:[Week 1]10)
-
Validation Formula
Going crazy. My current formula =IF(AND([Time Missed / Used (In Hours)]1 < 19.99),CONTAINS("Not", [Excused/Not Excused]1:[Excused/Not Excused]1, ".25", "1"))) = #UNPARSEABLE The goal here is to return .25 or 1 into a cell "Totals" if cell "Time Missed / Used (In Hours)]" is less than 19.99 and cell "[Excused/Not Excused]".…
-
delay in each Task
In the created project management fields, there is a start and end dates for the task assigned to the person I would like to inquire about the following cases: When I delay the task completion date, for example 3 days, how can I later review the dates and days of delay in each Task ?
-
Dragging down date formulas
I am trying to drag down dates to populate year days using formulas. It does not go to the next day using drag down. Is there any trick to it? Here is the example Date1= 01/01/2020 First Cell =$Date$1 - VALUE(YEARDAY($Date$1) - 1) = 01/01/2020 Second Cell =$Date$1 - VALUE(YEARDAY($Date$1) - 2) = 01/02/2020 Third Cell…
-
Formula to use to count multiple choice answers in a column by answers
I'm trying to figure out the right formula to use to count multiple choices answers in one column in my sheet. I'm hoping to have this information roll up into a dashboard. But, for the cells that have multiple boxes/answers checked, it is only counting the first answer, not the others. Any suggestions?
-
Multi select option in my dropdown options keeps reverting back to single select - why?
I am not making any edits to any column properties and can't explain why it has changed overnight multiple times. Has anyone had this problem or know why it is happening? Thanks!
-
Issue with Formula for RYBG Coded to Status
I am having issues with only one color in my formula for RYBG coded to the statuses I have. It appears Yellow always renders and invalid but the other colors do not. What am i missing in my syntax? =IF(Status5 = "Complete", "Blue", IF(Status5 = "On Track", "Green", IF(Status5 = "Off Track", "Red", =IF(Status5 = "At Risk",…
-
About using COUNTIFS formula
Hi, I am trying to use a COUNTIFS formula to identify the number of cells from a column ('Age Range') with a drop-down box with various options ('Under 18' / '18 o 30' / '30+') and are from a particular year in a 'YEAR' column. I know that this is fairly basic but I am a bit of a novas at formulas. Cheers Peter
-
How to count data in children rows based on criteria in parent rows
Hello all. I am thinking this would best be done in a Sheet Summary but my brain seems to still be in winter break mode. Hoping someone can point me in the right direction. My Smartsheet is a list of courses (parent rows including course title and date) with participants (children rows including participant names and a…
-
Completed form populates in Master Sheet - how to automatically copy that row to another sheet
I have 8 Associate Directors who are covering different AREAS of the world. When a completed form populates my Master Sheet, can I direct it to copy that row to the correct AREA sheet according to the AREA chosen? (I would have 8 AREA sheets that would feed to 8 different Dashboards)
