-
SUMIF Not Working
Hi, I'm running into issues when trying to use as SUMIF function in my sheet summary. I need to have it add together all the percentages in the red square under the column "Capacity Rating." The goal is to be able to create a SUMIF for each project manager in the division so we can see what their workload capacity is…
-
Count Function not working
Hello, I am using a COUNTIF function as shown in the screenshot attached, and it is grabbing the "Complete - Handover to VAR" Status field, but not the "ONB - No Reply by VAR" status field. There is some conditional formatting applied, but I'm not sure what the formulae isn't calculating the ONB - No Reply by VAR field.…
-
Move Row w/ Formulas
I have 3 sheets that are being used in tandem: Sheet 1 Registration Data Sheet 2 Travel Requests Sheet 3 Cancelled Registrations Sheet #1 has a "registration status" field (dropdown). This field is being pulled into Sheet #2 by using an Index/Match formula. If the registration status (on sheet 1) changes to cancelled, I…
-
Action based on System-Generated Modified Date/Time
Is there a forumla I can create that will check a box based on the auto-generated timestamp? Screenshot: I am looking to check the AM/PM box based on entry time (anything before 12PM would check the AM box and anything after 12PM would check the PM box).
-
Formula for Counting RYG by Child Row
Hello - I'm trying to add to a Dashboard. I need to see status by color for each child row. I also need a count by each child row (Admin, CPM, etc.). Help! Thank you.
-
AVERAGEIF or AVG ??????Why is this not working and how do i get it to work
So i basically want to calculate the average of all completed query. In the picture above there is a formula that calculates how long the task takes. If is not complete it does not have a data and the formula will show the #error above..... this i think is where i am going wrong i just dont know how to change it... Please…
-
Creating a formula that looks for criteria in a range and searches for that combo in a row
Hello, I hope I explain this the right way. I want to to find if a specific (row-level) combination of employee and date that exists on the first sheet also exists on the second sheet and if so, use a formula to flag the row that has the combination. For example, if Alex and 06/16/20 exists on the first sheet, I want to…
-
SUM IF Name and Points
I need to calculate the total number of points in the "Points Column" by each person in the "Name" column and I cannot figure out how its calculated. I tried to brainstorm with another co-worker and we both had trouble trying to figure this one out. Please advise.
-
vlookup/index/match to place data from one sheet into another
I compile safety data using a form that is filled out by my safety manager. In it he enters the date and if an incident occurs. If no incident occurs it uses a calculation (from my last discussion topic, still having circular reference errors) to sum the total number of days since the last incident. My question, which has…
-
HELP!!!
OK, I need help with a counting formula - This example works in Excel, but not in Smartsheet =IFERROR(COUNTIFSG14:K14, “P”)/COUNTA(G14:K14),””) The goal is to count the number of populated columns in the row only - and get a % in the score column. if blank, no value - 1 (f) = 0% 1(F) and 1(p) = 50% 1 (p) = 100% 2(p) and…