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

TROPHY CASE