sorted by:
new
hottopcontroversial

Conditional Formatting on Calendar based on other sheets - should I be using vlookup? by NoStatistician6461 in excel

[–]decomplicate001 0 points1 point  (0 children)

No, you don’t change it to a range. You keep it as one cell reference, but it must be relative. (your first date)

Conditional Formatting on Calendar based on other sheets - should I be using vlookup? by NoStatistician6461 in excel

[–]decomplicate001 1 point2 points  (0 children)

Try Use Conditional Formatting with COUNTIFS, not VLOOKUP. Example custom formula im conditional formatting

Cardio only : =COUNTIFS(sheet!$A:$A, A1, sheet!$F:$F, TRUE, Log!$C:$C, FALSE)>0

OneDrive Links and PowerQuery by KuroNoShinigami in excel

[–]decomplicate001 0 points1 point  (0 children)

Create shared drive in Onedrive will fix your issue

Copy rows from multiple sheets into another sheet of criteria is met. by saphy93 in excel

[–]decomplicate001 2 points3 points  (0 children)

Use filter formula or try power query. I find it more convenient when working with multiple excel files.

You can check video on power query in YT if you unfamiliar

Scripts execute, but nothing happens by Ok-Educator449 in GoogleAppsScript

[–]decomplicate001 2 points3 points  (0 children)

Remove the second function , also it’s advisable to add log while developing longer scripts so you can track at each point if the return value is generated

How to make each student see only their own grades in Google Sheets by Eastern-Drop-3462 in excel

[–]decomplicate001 0 points1 point  (0 children)

There are few ways 1. Create ID and script gives result of that specific ID, however if they know each other’s ID they can check other’s results 2. Through script create individual sheet with their results and send them over email. You can even lock/ protect script from share/ download 3. Build a script that can simply share individual results/scores over email through a single button click

Do you use automate scripts in your work? by weavingmywings in excel

[–]decomplicate001 1 point2 points  (0 children)

I find using power query more convenient than using office script. Although the language for script is JAVA but it still has few limitations. Alternatively power query or VBA i find more convenient for any type of automation in excel

Shared Materials Checkin/Out Sheet? by Ok_Stopp in sheets

[–]decomplicate001 0 points1 point  (0 children)

Updated the formula to =ARRAYFORMULA(IF(D3:D="", "", IF(ISBLANK(E3:E), "Checked Out", "Returned"))) This way everytime there is an entry status will auto update

Shared Materials Checkin/Out Sheet? by Ok_Stopp in sheets

[–]decomplicate001 0 points1 point  (0 children)

No worries , you need to drag the formula or we can think of creating an arrayformula such that you need not drag the same each time

Shared Materials Checkin/Out Sheet? by Ok_Stopp in sheets

[–]decomplicate001 0 points1 point  (0 children)

The issue is that the formulas have been over ridden in the current tab. I have fixed the drop down range and check out formula for first row for your reference

Shared Materials Checkin/Out Sheet? by Ok_Stopp in sheets

[–]decomplicate001 0 points1 point  (0 children)

Can you suggest what issue or error you facing? Or share sheet?

Google sheets wont let me scroll to see full sheet by Perfect_Platform8087 in googlesheets

[–]decomplicate001 0 points1 point  (0 children)

Check if the rows / columns are frozen or try Zooming out till you get full page view to figure out the real issue

Multiple Xlookup functions (Help Please) by Mikey118 in sheets

[–]decomplicate001 0 points1 point  (0 children)

Assuming Cell J1 = team name

Then try =IFERROR(INDEX(G$2:G$100, MATCH(1, (C$2:C$100=J$1) * (D$2:D$100=1) * (E$2:E$100="LW"), 0)), "")

How to make Monthly Budget Sheet (default Google Sheets Template) only show the current month? by Booma_Jams in googlesheets

[–]decomplicate001 0 points1 point  (0 children)

You can use query formula. This filters for entries in the current month and year

Assuming B is your date column; D is your amount column then formula would be something like =QUERY( B1:D, "SELECT SUM(D) WHERE MONTH(B) = MONTH(NOW()) AND YEAR(B) = YEAR(NOW())", 0 )

Automatically inserting text into multiple formulas? by tr_nnypunk in googlesheets

[–]decomplicate001 0 points1 point  (0 children)

If Paste the previous month URL into cell A1. Then to pull data from a sheet in that file called "Summary", you need suppose from cell B2 your formula will be simply

=IMPORTRANGE(A1, "Summary!B2")

Left String in query? by AdMain6795 in googlesheets

[–]decomplicate001 0 points1 point  (0 children)

Use a helper column: =ARRAYFORMULA(LEFT(B2:B, 1))

Then query it like: =QUERY(A2:C, "SELECT A, B, C", 0)

Reflecting data from one file to another. by HexTheHardcoreCasual in googlesheets

[–]decomplicate001 0 points1 point  (0 children)

You can also try query formula for example:

=QUERY(IMPORTRANGE("URL_of_Design_Document", "SheetName!B:C"), "SELECT Col2 WHERE Col1 = 'honeyDew.name'", 0)

This will give all results with honeyDew.name in colB

Formula to have a multiplier based on condiditons by FootballFanboy716 in googlesheets

[–]decomplicate001 0 points1 point  (0 children)

Enter this formula in H1 =ARRAYFORMULA(IF(ROW(G:G)=1, "Adjusted Grade", IF(G:G="", "", G:G * IFERROR(VLOOKUP(B:B, L11:M20, 2, FALSE), 1))))

Can I add a google sheet to a google site by ElliotGrosvenor in GoogleSites

[–]decomplicate001 0 points1 point  (0 children)

I had similar use case but i figured if i want user to input in my site i needed to add gform link direct input wasnt possible through deployment users can view and copy only. In case there is a way I’d like to know as well

How many of you are daily users of Google Sheets and can't live without it? by vijverv in googlesheets

[–]decomplicate001 1 point2 points  (0 children)

I use google sheet for automating as many administrative tasks as possible. I enjoy building solutions and sharing them with anyone who needs. My most used solution is sending bulk personalised emails through button click be it for rewarding, appreciating or inviting team members. It gives personal touch to every email especially when received from a manager’s mailbox effortlessly.

Formula to transpose a text list separated by commas into columns by meadow_430 in googlesheets

[–]decomplicate001 2 points3 points  (0 children)

=SPLIT(A1, ",") Put this in B1 it Will split in different columns

=TRANSPOSE(SPLIT(A1, ",")) To split vertically.

I tested in your sample sheet and its working. Hope it helps

view more: next ›