-
Formula to count the number of characters after a symbol
Hello. I am attempting to write a formula that will count the number of characters that follow a "-", and use the resulting number to determine if the type should be a "PO" or a "SWA" using an IF statement. I found a formula that will pull those characters following the "-", but it just gives me the actual 2 numbers…
-
Using a Vlookup and Sumifs in the same sheet ?
We have a master job list which we use to create our new project references. There are a lot of requests with a range of values ? I have a separate sheet where we populate with those projects we want to keep a closer eye on costs on picked up from other smartsheets ? The process being, I type in the job reference and it…
-
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…