-
Newline for Mapping
Hello! I have been creating a sheet that pulls data from a hotel database and then maps it into a pdf. I have been trying to get the sheet to pull as many suitable (in this case, from the same town) hotels as possible. The only way that I have been able to do this is by using =JOIN(COLLECT({Hotel Database Name Range},…
-
Average based on 1 criteria
I'm sure this is user error but I'm trying to average out compensation based on the job code then I'd like to create either a data mesh or vlookup to fill in the blank compensation with these averages. I've tried having a seperate sheet that has the job codes and then I'm trying to use the averageif formula. However I keep…
-
How do I enter criteria to return specific results, but not using filters or dynamic view?
I'm curious if anyone has an in-sheet solution for this. I have a lot of data related to store information (store #, address, software versions, regional manager name, etc.). It encompasses all information about a store location and there are over 1800. Is there a way to build a sheet so you can type in the store # and…
-
Schedule Variance
How can I copy columns from one template and add them to a different template? I want to add the date variance column from the Project Gantt and budget template and add them to the Project plan template. I just want a way to baseline and track schedule variance.
-
JOIN DISTINCT CHAR(10) List on Sperate Rows
Hi, I have the following formula which collects a list of a dropdown column, and removes duplicate values, is there any way that the returned list of values should be on separate rows of this column formula? =JOIN(DISTINCT(Dropdwn:Dropdown), CHAR(10)) Thank you,
-
Help combining: IF INDEX MATCH
Hi, Please help me with my formula, I'm trying to GET a Contact Column, based on matching criteria, (The columns referenced are from a separate sheet.) I tried using: =IF({Sheet 1 Range Status Column}, "Approved", INDEX({Sheet 1 Range Contact Column}, MATCH(HAS(@cell, Reason@row), {Sheet 1 Range Reason Column}, 0))) It's…
-
Formula returning 0% instead of correct value in the sheet...
Not sure why my formula (using Index and Match) is returing 0% as a result of matching to another sheet? The correct data in the cell is = 55%. All other columns with same formula working correctly but one dept is showing an error o= 0%. Here is the formula =INDEX({Feb Score Column - BEAUTY}, MATCH(UII@row, {UII Store -…
-
Why can't charts widget select columns from sheets?
I'm setting up standard line graphs through using the charts widget on a dashboard. I am pulling the source data from sheets which get updated once a quarter with information I would like added to the report automatically. It seems that I can only select a data range and not select the entire columns so that the graphs…
-
Calculating average time spent in each phase
I am looking to create a sheet that moves through our 5 stages of work and how much time is spent in each phase. What is the best way to go about this?
