-
How to get VLOOUP to skip an instance if specific condition not met?
I am getting out of my depth and would like some help with a complicated equation. Background Info: Trying to streamline an item check in/out system that uses barcode SKUs and an item condition as a freeform explanation from the user. An item can be checked out/in by users and when they are checked in it will prompt the…
-
VLOOKUP Help
Hello, I want to look up the number of contact tracings interviews a staff member can do for "today's date." The contact tracers enter the number of interviews they think they can complete into a sheet called Contact Tracer Projected Capacity. The Contact Tracer Projected Capacity sheet includes the following columns:…
-
Conditional Formula with Date requirment
Im having trouble combing a conditional formula. Both parts work on their own but when I try to join them it breaks. So far this is what i have =IF(AND([FINISH]1< [Go live Date]1), IF(Status1 = "In Progress", 1, IF(Status1 = "Not Started", 1, IF(Status1 = "At Risk", 1,0))))) I'm trying to do a numerical count. If the…
-
Formula for Gantt Progress
Hopefully I can explain what I'm trying to accomplish here... When using the Project Template, SmartSheet shows the % complete overlaid on top of the duration bar in the Gantt Chart. Right now we're using colored icons to indicate whether a task is on target for completion (the progress bar is ahead of the "today" dashed…
-
Day of Week instead of short date
Hello, I would like to have a formula in place that automatically selects a day of week based on the date we paste in the "Bid Date" Column. When 3/26/18 is loaded into [Bid Date] Column it produces "Monday" in the [Day] Column, and so forth... Is this possible?
-
Formula range extends to include new rows/entries. Sheet Summary
I'm using Sheet Summary to sum amounts on a sheet where new entries are occasionally added via forms. I want the new entries to be included in the range of cells summed, but that's not happening. Any tips?
-
Formula for tasks/Sheet Summary
So I'm at another roadblock so bare with me... I have a current formula that tracks the prior day's target tasks and a formula that tracks the prior day's completed tasks. However I want to incorporate my overdue tasks in these formulas as they still need to be accounted for. I was able to add my overdue tasks to my daily…
-
Nested If Or to control symbol
Hi All, I'm trying to set a symbol (Red, Yellow, Green) in a column based on the individual values in three columns. We'll call the columns the contain the values "Carrots Available", "Fudge Available". and "Veal Available" and the column with the symbol "Basket Status". If Carrots = 2, Fudge = 5, and Veal = 4 then the…
-
My first VLookup
Hello, and thank you in advance for your help. I am having trouble displaying data using a VLOOKUP function (I have never used one). My formula reads as follows: =VLOOKUP(Predecessor@row, {PPPredTask}, {%Complete}, true) Its goal is the following: Based on the value in the Predecessor Column in my sheet, I would like to…
-
Date range calculation, count month numbers
Hi All Could I please ask for some help with a date formula? I'm working on an online education project. Each module takes around 6+ months to complete, see below the date range that starts on 14 July 2020 and ends on 25 Jan 2021. I need to count how many modules occur in January, how many in February, how many in March,…