-
Formula's won't work together
Hi! I need to get the below formula to capture both project stages but when I add them together it gives me zero which is incorrect. I need the metric to match the report on the dashboard, any help is appreciated! =COUNTIFS({HR Projects - PMO Range 4}, >=TODAY(1), {HR Projects - PMO Range 4}, <=TODAY((30)), {HR Projects -…
-
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…