-
How can I use a formula to count the total in a column that has specific values
I am try to count the number of people who are internal coming to an event, so we have a form that people put in what their organization is. If it is internal, it should have Geisinger in the name, but there are many branches, so it could be Geisinger (insert campus names). I want to calculate how many people have…
-
Weekly Volume Maximums
Hey all! I am wanting to create an availability calendar for our call center. We can only accept about 200 calls/week. The goal is to auto-sum the daily volume column for a week period and to set a condition that notifies sheet viewers that we are unavailable to accept anymore calls that week if it is over the 200 call…
-
VLOOKUP equivalent -- #NO MATCH error
Hello! I have a formula I'm using across several sheets referring to a source table. On 9/10 sheets, the formula works just fine. However, on one the exact same formula yields a #NO MATCH error. I've double-checked my references and everything looks good -- e.g., the match criteria does indeed exist where it should. Any…
-
Average children with IF
hi, i have sheet with ~300 parent row and ~1200 children row. i try to sum the progress in parent row with IF on his children. for example : if one of the children row is "sent to fabrication" he get 100% and i have five children row i want to see in parent row the value 20% progress. (1+0+0+0+0)/5
-
I have a column that is Closure Rate % -- and want to indicate trending
I have a column called Closure Rate - which is a % formatted field. I want the insert a column to the right that indicates if the value in Closure Rate = <25% then show up arrow, if not show down arrow. is this possible? I have the column properties set correctly. =if([Column12]3<25%,1,0)
-
Different View of Report, depending on the location, from where the report is accessed.
I have a report called "My Tasks" in my workspace, I also have a shortcut to this report in my Dashboard. When I click the report from the Dashboard shortcut, the view is different from when clicked through the workspace itself. Different columns are seen in the two views, although I have set it to show only one. It even…
-
Conversation - information included when @mention
Hi all, Is there a way to include more information in the email alert when you @mention someone? For example - I have a To Do List that I want to ask a question of another staff member however when I @mention it to them the email that they receive only includes the name of my Worksheet and not say the "Task Name' which…
-
IF AND formula with between dates
I'm trying to toggle and RYGG status field with a formula. The idea If the contract send day is more then 14 days ago and the contract hasn't been executed I want the status to be RED. If the contract day is more than 7 days, less than 13, and the contract hasn't been executed the status should be YELLOW. Otherwise it…
-
#Blocked when using SUMIFS formula on sheet summary
I am getting a #BLOCKED error message when trying to use a formula. I copied a formula that worked and changed the column name, which then gave me the error message. Not sure what is wrong or how to fix it. =SUMIFS([COBID # of Consultants by Project]:[COBID # of Consultants by Project], Level:Level, =1) - this is the…
-
Can you change the display form?
If you double click a row in a sheet, it opens a form that displays all of the data for that record. Right now, it displays values in columns that I have hidden. Is there a way to remove those columns from the display form?
