-
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?
-
How to use multi-select dropdown list as criteria for sumif/vlookup
Hey guys, thanks in advance for you help. I have three sheets that I am working with: a database (of sorts), a grid-form summary sheet, and sheet that contains attributed values. To simplify, I will only use a, b, c, and d as production point names and whole percentages as attributed values. The "database" contains unique…
