-
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…
-
Is there a way to Count items that are Closed Today?
I have work queue and status column. I would like to count the number of items that are closed (daily) or today. I understand this number would change throughout the day. Can someone assist? Thanks!
-
How do I get the Web Content in my Dashboard to print or save as a PDF?
My Google Sheet shows up in my dashboard with no issue but when I try to save as a PDF and or print the section with my web content widget is blank. How do I get the Web Content in my Dashboard to print or save as a PDF?
-
Publish Calendar Link for a Filtered List
Is it possible to publish a calendar link that only displays items form a filtered list isn't of the entire grid?
-
"IF" function question - Urgent if possible
I have a sheet where i am tracking multiple different tasks for completion. i am attempting to create an (Overall status) once a few key items are marked completed, and or box is checked. Can someone explain how this can be done? Example: EDI setup-completed, testing successful check box checked, contracted check box…
-
Multiple IF/AND Statements
Hoping someone can assist me with a formula. I've spent quite a bit of time trying to figure it out on my own and can't seem to get it. I have multiple criteria to determine the value of a field. The field values would be Ops, G1, NG2, G2, and Full depending on various criteria. Here is the logical expression: If [Tshirt]=…
-
How do i write the following formula
I am trying to write a If-nested formulas that works out the following. What i am trying to say with this formula is the following: IF the status is Complete and the planned end date is today or within five working days = Green IF the status is In Progress and the planned end date is today or with in three working days =…
-
Sheet ownership was transferred without a request
I believe there was a side effect to a mistake I did. Our structure is one workspace for all of our projects, with each project in a separate folder. I mistakenly removed sharing of my coworkers at the sheet level that were shared at the work space level. When I did this it removed their access from the entire workspace.…
-
Counts of values in a multi-select column
I'm trying to count the number of values in column that allows for multi-select. In this case, column is Contract Type - and the request can involve multiple contract types...I'd like to be able to count/total individual the types of contract types.
-
updating cells without loosing easy overview of historic data - how to?
We have a list of customers, where the invoice changes from month to month according to use of specific items. Example: Customer A will in January pay for 2 item Y, 0 zero item X, and in February pay for 3 item Y, 0 item X and in March pay for 1 item X, 3 item Y. Q1: Is it possible to have the customer update this…
