-
Summing totals with 2 variables
I am trying to sum the amount of time it takes a specific individual to complete a certain task. I am trying to determine the best formula to use to accomplish this. I have been using SUMIF but not sure how to get it to work with two variables My worksheet has 3 columns: Name, Task, Minutes I need to identify the person…
-
Help with Metric sheet
Hello, I created this metric sheet to get totals for overall performance but I can't get the totals to populate from the sheet that is being referenced. Not sure what I am doing wrong,
-
How to make % frequency chart in dashboard (reasons for QC failure)
Hi, I am trying to make a chart in my dashboard that displays the reasons for QC failure as a percentage of overall frequency. The input is from a sheet with a column as shown below. You can select the mode of failure from a dropdown menu, and can select multiple items if there are multiple modes of failure. "In Dashboard"…
-
Create cell reference based upon horizontal axis position
Is there a way to create a cell reference based upon a horizontal axis? For example, for a given column, I want it to always represent the cell directly to its left. For this example scenario, a new column will be added for every date and the new results will be entered into that column - Since the new date column will…
-
Inventory Status: Reordered (How do I do it?)
Hello, I am developing an inventory reorder system and I need the status of the line item to show "Reordered" when the check box is checked under "Order Status" I recognize that there are multiple true statements within my formula so how can I show "Reordered" while the stock quantity is below the ROP? I have been trying…
-
URL Query string did not move with "Save as New" How to remedy?
I used a test workspace to create 2 data base sheets. One to hold existing info and one to hold newly created info based on existing. Users create this new data by clicking a URL to get to a form. I created a form and appended a query string to the form URL such that when a person clicks the URL, information from the URL…
-
Help For Colorblind Folks
Good morning! I struggle with trying to pick the appropriate colors from the fill and text palettes due to red-green color blindness. Would it be possible to have a text bubble with the name of the color pop up when you mouse over each color in a palette in any area of the application? It would be a huge help when…
-
How do I pull risks and issues from multiple projects into another sheet?
I am trying to create a programme view over a number of projects. I want to be able to gather all the risks and issues from the various project raid logs into another sheet so, it can be displayed on a dashboard. How is the best way to do this?
-
Notification with Attachments
Hi there, I would like to send a notification with an attachment based of a status change. The notification works, but doesn't include the attachment. I have seen on the community that this is not possible in SS - is this still true? If so, do you know of any good apps/software to automate that process? I have looked into…
