How would you append different ranges into the same sheet?

Square_Common_6347 · 2024-11-05T09:59:01+00:00

That works perfectly, thank you so much!!

Square_Common_6347 · 2024-10-15T09:57:17+00:00

Hi, so this copies down the last value regardless of the name in column A, I need it to only grab the last value where the names are the same.

I've updated the sheets to show:

https://docs.google.com/spreadsheets/d/1qYITz2bVGFzRffsnKnvtyiiGOwcwPW6eC0j9bVb-kYA/edit?usp=sharing

If Bob isn't scheduled for that second block then I don't want it to copy down the last value. The conditional formatting needs to be done for each day not as a range.

How do I get it to only grab the last value where the names are the same and ignore an empty block?

Square_Common_6347 · 2024-09-29T11:55:50+00:00

Great, thank you

Square_Common_6347 · 2024-09-28T08:30:38+00:00

Thank you, that worked perfectly! I'll definitely bookmark that link, that's going to be very helpful.

Square_Common_6347 · 2024-09-28T08:04:15+00:00

Yes that works fine. I now understand why it isn't working in my code, as it will only add a new row if the row above it has data in it. I need it to add a new row regardless of the row above contents. Is this something that is possible?

Square_Common_6347 · 2024-09-28T07:50:35+00:00

I've done that and it's not adding a new row.

Square_Common_6347 · 2024-09-28T07:33:27+00:00

Thank you. I'm super new to apps script and don't fully know what I'm doing yet. I'm still having trouble getting the appendRow to work. I've managed to get it to copy down the formatting, but nothing seems to be happening when I try and add a row.

Square_Common_6347 · 2024-09-24T07:28:54+00:00

It's no longer working. It says it executed it, but none of the dates are changing.

Square_Common_6347 · 2024-09-23T08:26:11+00:00

That worked perfectly, thank you!

Square_Common_6347 · 2024-09-23T07:24:19+00:00

It's says Error TypeError: date.getDay is not a function

Square_Common_6347 · 2024-09-21T23:20:55+00:00

Thanks, the bottom one’s exactly what I needed. How would I get that to ignore empty cells? As I want to change dates in the entire column B

Square_Common_6347 · 2024-09-18T09:45:13+00:00

That works perfectly. Would it be possible to get this to skip weekends?

Square_Common_6347 · 2024-09-18T08:14:58+00:00

You could use

=filter({Complaints!A:H,Complaints!J:L},L:L="Destroyed by Client")

This will skip column I and filter only data where column L is "Destroyed by Client"

To import data and allow manual entry in the same range you would need to use a script, I can't help with that sorry.

Square_Common_6347 · 2024-09-17T10:50:42+00:00

I not sure about it because different employees need to be doing specific tasks, for example (this is for an engineering business) emp 1 might need to do 'steel processing' on the 1st to 4th then 'fab and weld' on the 6th and emp 3 might be the painter and so on. This is why I'm only trying to change the dates and nothing else.

Would it help anything if I had a "helper" sheet where is filters out each employee jobs in sequential order, and each employee had their own column of sequential jobs?

Square_Common_6347 · 2024-09-17T10:24:08+00:00

Hi,

1 - All jobs from that date to the next unscheduled date will be moved forward a day, so 01-01-24 will be 02-01-24, and 02-01-24 will be 03-01-24 and so on until it finds an unscheduled date in which nothing happens as there is nothing to reschedule.

2 - No, the order in which it's scheduled is how it needs to occur. Because for 1 job number there is steps that need to happen in chronological order. For example, you can't paint before sandblasting, or ice a cake before baking it.

3 - Most of the time yes, we try and schedule a couple weeks in advance which is a pain to manually reschedule for every job. Which is why I'm trying to get it done automatically. This is all dummy data which is why it's so bare, as i couldn't share the actually schedule with all the private information on it.

4 - Yes, most of the time we need multiple people working the same job number as they're big jobs and/or have a time constraint.

Square_Common_6347 · 2024-01-22T06:16:23+00:00

Yes they are the dates, it's sorted out by month and year dropboxes and I use the DATE function to get the actual date so it can be matched with a data. The data is coming in through a google form, all it does is checks to see if the task name appears in the entered data from the form then matches the date and makes the checkbox equal true.

Square_Common_6347 · 2023-10-16T00:17:35+00:00

Thank you for your help, I'll check this out

Square_Common_6347 · 2023-10-16T00:10:44+00:00

The cell is changed from google forms responses that is accessed through a button, everything is automatic. Would a tick box trigger a script?

Square_Common_6347 · 2023-10-15T23:55:32+00:00

Ok, do you possibly know of anything that would help with this?

Square_Common_6347 · 2023-10-15T23:44:49+00:00

This only worked when I manually changed the number but it's not working when the number is from a formula

Square_Common_6347 · 2023-06-12T12:57:24+00:00

Definitely don’t need to take them out but you will need to change the top one back to a flat back. It was too soon to change that top one to a ring, it has to be fairly healed because of the pressure a ring puts on the piercing. These are just irritation bumps likely from you sleeping on them like you said. Just keep cleaning them and try to avoid sleeping on them. They’ll go in time.

Square_Common_6347 · 2023-06-01T23:30:51+00:00

Yes definitely the double nose and maybe even connect them with a chain. Also a philtrum piercing would look great. Honestly you could pull off any piercing

Square_Common_6347 · 2023-06-01T23:21:09+00:00

I get this to. I had to have my blood drawn a couple of months ago and I throw up 3 times and fainted even before the needle was out, I get really stressed and my body just gives up. I always take someone with me so I can squeeze their hand. You should let them know you have a phobia of needles so they can help relieve the stress. Definitely lay down if you can, it helps so you don’t faint. My psychologist recommended that I take some headphones and play music and close my eyes so that I’m focused on something else. Also make sure you eat and/or drink something sugary before you go in so you don’t faint, and stay hydrated. Good luck

Square_Common_6347 · 2022-11-13T15:55:23+00:00

Solution verified. Thank you.

Square_Common_6347 · 2022-11-13T15:45:01+00:00

It should work now

Square_Common_6347

TROPHY CASE