-
Index (Match?) Function
Hi all, I have been reading a lot of discussions on the index/match function, and cannot for the life of me figure out how to accomplish what I'm trying to do. I am making a new spreadsheet where I want to pull data from two different sheets. The data from the second sheet will be dependent on the data from the firstโฆ
-
How to Use Certain Contact Cells in a Column and Combine into One Cell
Hello, I have a project timeline/schedule where I want to take each 'different contact', in a column and combine them into a single cell so I can create a notification to the project team based on different tasks that change to 100% complete. My team uses a template for the timelines and I would like to set it up so weโฆ
-
Summary Sheet Formula
Hello, I'm trying to calculate a percentage using two summary sheet fields. My status field tells me how many locations are complete and I want to divide that result by 83 total locations =COUNTIF(Status1:Status86, "Complete", /83) Any pointers would be helpful, Thank you.
-
Automate Row reference in Sheet Summary Field
Hello, I have a sheet that regularly updates with new rows. I use the "Sheet Summary" tool to summarize columns of data that are then shown in reports. Whenever a new row is created in this sheet (by a form), the sheet summary field does not update to include that row in the summary. Is it possible to have the sheetโฆ
-
Unique Values for a Metric Widget in a Dashboard
Good Morning, I am trying to pull unique values (names) from a column, to see how many times those names appear and have that in a (Pie Chart?tbd). This is input from a form, so I'm trying to track engagement in the process via amount of entries per person. That being said, it may be better to track this along with theโฆ
-
Multi Select Column Stacked Bar Graph Formula
Hello, I am having trouble finding the correct formula to add a specific combination of multiselect selections that are entered in a row. For example, I want to count all instances of options a & b in a column. Also, in the same formula reference the status. Below is the formula we are using to count this with oneโฆ
-
Amount in negative
Hello, How can I show the amount in negative when the status changes. For example, here in the screenshot, the red highlighted one has the status 'OUT'. I want the amount to show in negative in the next column. Thanks
-
Automate Flagging at risk task based on approaching due date
Hi Community, I am looking to automate flagging a task if it comes within two weeks of one of its two due dates (each task has a recommendation date and approval date) and its currently not complete (of which there are two opportunities for it to be complete, the recommendation and the approval). The task must have aโฆ
-
Stacked Bar Chart using Metrics and multiple data sets
Hello, I am struggling to gather data together from multiple data sets to represent as a stacked bar chart. I have large spreadsheets that use dropdown options for data I need such as customer journey and impact rating (high, medium, low) there is a lot of other data in these sheets as well and they are over the 100,000โฆ
-
Assigning people
Hi Do I need a separate workflow to assign each person in different columns to a task? I like to assign all the below at once with one workflow