-
Flagging a Date and Time Overlap Across Multiple Days
Hi all, I need some help with a formula which I believe I almost crack but I don't know what I'm still missing here, I want to flag overlapping tasks across multiple days and times, as you can see below, I have different columns: Start date, end date, start time, end time. Start and finish are just switching the time…
-
IFERROR for #DIVIDE BY ZERO
Hi! I'm calculating the averaged RYG in parent rows that's tied to our Status column. Until the status changes to something other than "Not Started", the parent row displays #DIVIDE BY ZERO. I'm trying to use IFERROR to display blank but I'm getting an #INCORRECT ARGUMENT SET. I'm probably missing a parenthesis somewhere.…
-
If/and referencing multiple sheets
Looking to express the following: If [ID#] in sheet A is equal to [ID#@Row] (in sheet B), AND [Progress] in sheet A is between 90 and 100, show "Published" in [Progress] in sheet B, If [Progress] in sheet A is between 15 and 89, show "In Progress" in [Progress] in sheet B, If [Progress] in sheet A is between 0 and 14, show…
-
If function based on multiple columns
I have done formula on column 3 and 4 if column 3 returns yes and column 4 is blank, the status will return from column 3 but if column 4 has yes in it, the status will return from column 4 ignoring what is column 3 I want to add the column 5 in the same formula with the same principle if column 5 has yes, status will be…
-
Formula to generate a weighted average score
Hello! I'm trying to create a formula that will generate a weighted sum total across a couple of criteria columns after each column has been assigned a score. Each of the columns will have a drop down where we can select a score (from 1 - 10). Each column will have a different weight: Enterprise Priority: 35%; HR Priority…
-
Why does my MID formula work when I subtract the incorrect length?
I made typo in one of my formulas but it still returned the desired result. I want to understand so I don't end up with unintended results down the line. My goal is to extract the data that follows "Set 4:". So in this case the formula should return "0101". It should always return the data that follows "Set 4:". My…
-
How to get individual cells to show remainders.
I'm currently working on making two separate sheets. One is where providers can submit that they have extra of something (someone submits that they have 5 extra bags of concrete, another person submits that they have 7 sheets of metal, etc.) with their email attached (so multiple of the same kind of material cant be…
-
Countifs Formula
Hi Smartsheet Team, I have captured this student id no. 2307647 Programming session hours is 1.5 hours. (see below) Then, I worked on the metrics sheet to show the hours on the programming session - Complete. It shows only 1 hour, even though I added the decimal spaces. the formula for Programming sessions - Complete is…
-
Date/Time formula - Need help
Hi all, I need to add a date and time check to a SmartSheet I am working on. Currently, we are trying to track late arrivals into our building. Example: =IF([Actual Pick Up Time]@row > [Critical Pull Time]@row, "Late", "On-Time" =IF([Scheduled Pickup Date]@row = [Actual Pick Up Date]@row, "On-Time", "Late") The above…
-
Counting Opened Opened for a Particular Year
Hello, I want to count the number of tickets that were opened in 2022. I am getting a invalid date type error message. The date range in the cross reference is restricted to dates only. =COUNTIF({Date Requested}, YEAR(@cell) = 2022)
