Get the value of one cell based on drop-down menu items on another sheet

I have named 2 leaves as leaf 1 and leaf 2 …

Sheet 1: Contains drop-down list for column B4. Based on the selection of the item, the result of the open price displayed in column D4 is retrieved.

Sheet 2: Contains 2 columns.
Based on column 1 ID The open price of sheet 1 must be retrieved and should be displayed in column 2 of sheet 2 …

Note: I do not want to change Sheet1 and 2 in any way. Please do not add extra columns in Sheet1 and 2. That way I can achieve the result.

I do not have to change any criteria to get the result because I'll retrieve past data and do some complex operations.

Link sheets

ux field – Can we open the keyboard when the mobile application has the status with the bottom sheet?

I am working on a mobile application. It's like ordering an app for groceries, but wholesale, not retail. So the user can order 100kg to 1,00,000kg for sales purposes. The order range is huge and therefore UX needs help.

I am a user and can order between 50 kg and 1,00,000 kg. I choose as a bag that contains 50kg. However, if I give the opportunity to add items with the following design, it is very difficult to add 20 to 100 bags since the user has to click 20 times.

Enter image description here

I have decided to enter text, but I am not sure if it is already in the lower sheet mode. How can I open the keyboard for all users to enter a specific value?
Need help with the Ux design.

More – I've redesigned the pop-up, but this is a bit complex, as shown in the following picture.

Enter image description here

Assign a rank in another sheet based on the average

I have a list of names with an average for every day from Monday to Friday next to it. A subset of names in this list is highlighted. I want a macro to assign ranks of highlighted persons based on their average and to put a value of their rank in a row of another sheet where each person has a column. There is a line for every day.

Example. 5 people highlighted in a list from 1 July. Macro looks at another sheet (named Workbook) and finds a row that corresponds to July 1st. Then find the column that corresponds to the person with the lowest average. Put 1 in her cell. Repeat this with 2, 3, 4, 5. If 8 marked persons would do this 1 to 8.

I hope that makes sense

Formulas – Dynamic master sheet that retrieves red-formatted cells from another leaf

The title may be a bit too ambiguous, but I will try to give an overview as well as I can;

I have a Google sheet with several "leaves" or tabs (as I like to call them) in it.

The Main tab is empty and the remaining cells have different data. The data that is close turns their respective cells red, I have existing conditional formatting to do this.

What I want to achieve is that the main tab basically checks all other tabs for possible red cells and insert them into the main sheet in a vertical column.

Here is an example:

"Second Rider"

  • (A1) Date 1 (green)

  • (A2) Date 2 (red)

  • (A3) Date 3 (red)

  • (A4) date 4 (green)

"Main tab"

  • (A1) Date 2 (red)

  • (A2) date 3 (red)

As you can see, "Main tab" does not ignore any green Cells off "Second Rider" and just grabs those Red, In my case, there are many more tabs, not just 1.

I have a feeling = IMPORTER can help in this scenario? Could be.

Any help is greatly appreciated!

Group a sheet automatically in Excel

I have a sheet with thousands of lines of information, most of the information consists of 3 rows and 10 columns, each of these 3 rows contains work that I have done in certain places, and column 1 is where it was in If I want to work to sort the whole sheet by the places where the work was done, so if I sort it by column 1, it should contain 3 lines,

See picture cell J1 shows the total cost and cell A3 says the apartment where it was
How do I get these 3 lines as 1 automatically?

With balance sheet changes at FIFA 20

Breaks are pleasant. Law? No longer. Counter-attacks are more difficult than ever, given the changing record of FIFA 20. A slow, deliberate build-up focused on ownership and movement is far more effective on FIFA 20 coins than on FIFA 18. By maintaining ownership you not only have a much better chance of scoring points but can also gain the midfielder's wins. The last thing you need is for your opponent to put constant pressure. So next time you land on your hind foot, try a more conservative approach. Once you've got the ball, put some passes together and slowly work your way up the court. Do not be afraid to go backwards. sometimes a step backwards offers two steps forward.

It is difficult to judge the goalkeeper, so it is better to leave this task to the AI. However, you should pull this target under the right conditions and take this player apart. By pressing Triangle or Y you can let your goalkeeper sneak out of the gate to an attacker. It is a tricky task that should be used in moderation. However, if you do it right, your goalkeeper will sweep the ball off a competitor's feet until it finds a shot. Go and also a skilled opponent will lift the ball on the head of your goalkeeper. If an opposing player makes a heavy touch in the box and no defenders come to your rescue, consider the goalkeeper.

You need to get off the field to become a finisher. Finishing is more about texture than formulation. By doing so, you'll know exactly how good your shot will be before it leaves your attacker's foot. You want to consider some factors when firing. First, make sure your striker has a clear line of sight to the goal. Otherwise, the shot will be blocked by a guardian. In addition, balance and body contour are very important. Buy FUT 20 Coins. If your player leans backward or points in the wrong direction, it can not ensure enough power or precision for its shot. For example, when Cristiano Ronaldo heads the ball standing, his shot does not have as much speed as in an attack. You should shoot if possible with the player foot.

Formulas – Change the default values ​​when Google Forms fills in a Google Sheet automatically

There is a Google Form linked to a Google Sheet: When a response is posted to the form, a new line is added to the sheet (here's a quick tutorial just in case).

Is it possible that this newly added line contains some formulas?

For example, suppose the web form asks

Surname
Date of birth

Then I want the issued Google leaf looks like this

Name | Date of birth | Older
                                     = TODAY () - B2  

While by default, the third column is created without a value

Script that duplicates the template sheet several times to a new file and renames the tabs

I'm looking for a script that will create a menu item that will allow me to copy a template sheet I created into a new Google Sheets file, ask for the number of copies of the template to add, and rename tabs for each copy in the new one File. In addition, the permissions of the original template must be preserved during the copy process.

I have to create new files for my company cash processing template, which requires me to enter the tab names for each month, month, and date in the tab name. I have attached images of the template file as well as the desired result. The images are from Excel files, but I have already migrated them to Google Sheets.

template file

Result after execution of the script

Example:

Sheet with template file in which the script is executed:
Tab name: Template sheet

New sheet file where template copies land:
Tab names: June 1st – June 30th

I found this script that does some of what I want. It copies my sheet to a new workbook based on the sheet ID, but I really need the script to create a new file and make multiple copies of the sheet in that file, rather than just one.

Function copySheets () {
var copySheetsContaining = Browser.inputBox ("Copying leaves with names that contain:");
var destinationId = Browser.inputBox ("Enter the target spreadsheet ID:");
if (sheetMatch (copySheetsContaining)) {
for (var i = 0; i <sheetsCount; i ++) {
var sheet = leaves[i];
var sheetName = sheet.getName ();
Logger.log (sheetName);
if (sheetName.indexOf (copySheetsContaining.toString ())! == -1) {
Logger.log ("COPY!");
var destination = SpreadsheetApp.openById (destinationId);
sheet.copyTo (destination);
}
}
successAlert (& # 39; copied & # 39;)
} else {
noMatchAlert ();
}
}

// Determine if sheets match the user input
Function sheetMatch (sheetMatch) {
for (var i = 0; i <sheetsCount; i ++) {
var sheetName = sheets[i].getName ();
if (sheetName.indexOf (sheetMatch.toString ())! == -1) {
return true
}
}
return incorrectly
}

// Warning if no sheet matches the user input
Function noMatchAlert () {
var ui = SpreadsheetApp.getUi ();
var result = ui.alert (
"No leaves match your input",
"Try again and make sure you do not use quotation marks.",
ui.ButtonSet.OK);
}

// warning after successful action (copy only)
function successAlert (action) {
var ui = SpreadsheetApp.getUi ();
var result = ui.alert (
& # 39; & # 39 ;, success!
"Her leaves were successful" + action + ".",
ui.ButtonSet.OK);
}

(Google Sheets) Copy the sheet to a new workbook and rename it

I'm looking for a script that can be used to create a menu item that I can use to copy a template sheet I created (several times) to a new workbook and rename the copies at the same time.

Example:

Workbook 1:
Tab name: Cash end (digital)

Copy Cash End (Digital) 30 times to a new workbook and rename each tab in (January 1) – (January 31).

I hope that makes sense to a certain extent. Thank you in advance for any help someone can provide, as I have not succeeded in my Google search for a script.

EDIT: I found this script that does some of what I want. My sheet is copied to a new workbook, but I have to copy it several times and rename it at the same time.

Function copySheets () {
var copySheetsContaining = Browser.inputBox ("Copying leaves with names that contain:");
var destinationId = Browser.inputBox ("Enter the target spreadsheet ID:");
if (sheetMatch (copySheetsContaining)) {
for (var i = 0; i <sheetsCount; i ++) {
var sheet = leaves[i];
var sheetName = sheet.getName ();
Logger.log (sheetName);
if (sheetName.indexOf (copySheetsContaining.toString ())! == -1) {
Logger.log ("COPY!");
var destination = SpreadsheetApp.openById (destinationId);
sheet.copyTo (destination);
}
}
successAlert (& # 39; copied & # 39;)
} else {
noMatchAlert ();
}
}

// Determine if sheets match the user input
Function sheetMatch (sheetMatch) {
for (var i = 0; i <sheetsCount; i ++) {
var sheetName = sheets[i].getName ();
if (sheetName.indexOf (sheetMatch.toString ())! == -1) {
return true
}
}
return incorrectly
}

// Warning if no sheet matches the user input
Function noMatchAlert () {
var ui = SpreadsheetApp.getUi ();
var result = ui.alert (
"No leaves match your input",
"Try again and make sure you do not use quotation marks.",
ui.ButtonSet.OK);
}

// warning after successful action (copy only)
function successAlert (action) {
var ui = SpreadsheetApp.getUi ();
var result = ui.alert (
& # 39; & # 39 ;, success!
"Her leaves were successful" + action + ".",
ui.ButtonSet.OK);
}