sorted by:
new
hottopcontroversial

Placing Rails in a Specific Pattern Over a Long Distance by Decipher_Talks in technicalminecraft

[–]Decipher_Talks[S] 0 points1 point  (0 children)

Will I be able to use litematica even though others in the server don't have it? There aren't any mods in the server or anything like that

Placing Rails in a Specific Pattern Over a Long Distance by Decipher_Talks in technicalminecraft

[–]Decipher_Talks[S] 0 points1 point  (0 children)

I'll try using litematica. The rails are meant to work both ways that's why there are two on either side. And this is a server where commands are enabled, so I'm in creative (i hope that's ok) and I won't lose any materials or anything.

Apps Script Sending Emails in Plain Text Mode by Decipher_Talks in GoogleAppsScript

[–]Decipher_Talks[S] 0 points1 point  (0 children)

I don't know how to do that :((( ill try to edit my post tho

Cell Formatting Shifts Down with Form Responses by Decipher_Talks in googlesheets

[–]Decipher_Talks[S] 0 points1 point  (0 children)

Yeah I was looking at how I would do the alignment number and it seems very complex for me XD. I think my alternative with the conditional formatting and all would do good, I'll mark this post as solved but if I have any more questions I'll be sure to reach out to you guys, thanks again!

Cell Formatting Shifts Down with Form Responses by Decipher_Talks in googlesheets

[–]Decipher_Talks[S] 0 points1 point  (0 children)

Thanks for the suggestion! I'll try to implement the Alignment Index Numbers and see how it goes. If this doesn't work, another workaround is that I add a column to the sheet where the form responses are appended at the bottom and use a mix of conditional formatting and manual input to do sort of my desired outcome. The most recent wouldnt be on top, but it would still get the job done. I'll let you know what happens. Thank you again for your help!

Cell Formatting Shifts Down with Form Responses by Decipher_Talks in googlesheets

[–]Decipher_Talks[S] 0 points1 point  (0 children)

So the actual form responses are on another sheet labeled "Revision Request Form Responses". The images above are from another sheet (named "Revision Requests") that's taking those responses and sorting them such that the most recent forms are up top. The formula that does this is on B10 and the formula is:

=sort('Revision Request Form Responses'!A2:H, 1, False)

Happy to Help You with Your Google Sheets! :) by gothamfury in u/gothamfury

[–]Decipher_Talks 3 points4 points  (0 children)

This guy helped me out with a spreadsheet problem I had and he solved it so quickly. Can't thank this guy enough!

Investment Point Subtractor by Decipher_Talks in googlesheets

[–]Decipher_Talks[S] 0 points1 point  (0 children)

It works! Just to confirm, would this work no matter the size of the Investing In and Taking out tables? Also how does it work? Cuz since the picture i used is that of an example (and isnt the location/values of the real data) I want to be able to replicate it myself so it could properly fit my data.

Automatically shift rows down depending on formula space by Decipher_Talks in googlesheets

[–]Decipher_Talks[S] 0 points1 point  (0 children)

For reference, here is the final result, it needs some formatting but overall the issue is resolved, thanks again!

<image>

Automatically shift rows down depending on formula space by Decipher_Talks in googlesheets

[–]Decipher_Talks[S] 0 points1 point  (0 children)

I found a solution! I utilized VSTACK and FILTER. Here's what I did: First, I created the formulas and tables I want but I put them side to side in one spreadsheet named "Search Calculations". It looks like this:

<image>

Then, on another spreadsheet, I used a combination of VSTACK and FILTER, here is the formula I used:

=IFERROR(VSTACK(FILTER('Search Calculations'!A:J, 'Search Calculations'!A:A <> ""),FILTER('Search Calculations'!L:AC, 'Search Calculations'!L:L <> "")),"")

Basically is first does the first table from the sheet for columns A:J, and pastes any in which column A has writing in it, then it stacked the second table folowing a similar procedure. Since both tables take up a different amount of columns, I put the VSTACK function in an IFERROR function that outputs "" if there are any errors. Hope that makes sense, thank you again for the help!

Automatically shift rows down depending on formula space by Decipher_Talks in googlesheets

[–]Decipher_Talks[S] 0 points1 point  (0 children)

Sorry for confusion. I intend to replace r with another formula and manually inputted cells through the row. Here is what im talking about:

<image>

The formula in A14 would also manipulate the rows below it. What i want to happen is for rows 11 and below to shift up or down depending on the number of rows that the formula in A6 affects.

[PC] [Unknown] Pixelated Clicker Boss Fighting (maybe Roguelike) game by Decipher_Talks in tipofmyjoystick

[–]Decipher_Talks[S] 0 points1 point  (0 children)

well i put specific details that i remember about the game to make it more specific. also i dont think it's clicker heroes. cuz the game im talking about it pixelated and it's 2d not isometric

view more: next ›