-
Using COUNTIF in Sheet Summary
I am trying to use a COUNTIF formula in the Sheet Summary. I have a column called, "Current Project Status." I want to count the total number of times the word "Operational" appears in that column. I have entered this into the field with no luck; "=COUNTIF(Current Project Status:Current Project Status,Operational)" I have…
-
Return Blank in column
Hello, I am trying to populate a Pass/Fail Column based of the answers in a pervious column. I am using IF formula, =IF([1. Pass Meds]@row = "Yes", "Pass", "Fail") but not sure how I should add in if blank. Any help is much appreciated!
-
Counting Dates within a Date column
Hi all, I'm trying to set up a formula that counts specific dates within a date column, using the following approach: =COUNTIF({Reference 1}, "31-12-2020") It keeps returning 0 when there are least 4 dates within the target column that match the specified criteria. Can anyone advise how I can fix this? Many thanks in…
-
End of Year Rollover
Good afternoon, I have been given the task to do a year end rollover. This has me duplicating each sheet, but then having to go in and change formulas for the additional sheets I'm creating. This is a very time consuming task, and I'm sure there has to be an easier way. After googling and trial and error, I have yet to…
-
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…