Moving closed "tickets" to a second sheet
I have a sheet where we log our support as it comes in. I have a "completed" check box to check once it is finished. It also has a date created field.
I setup a second copy of the sheet. On the first sheet I added automation to move any row that is "completed" and over 3 days old to the second sheet.
This works well. However, I'd like to add a "auto number" field to the sheet. but when I do this it tells me that the automation can no longer run.
So, my question is this: Any way to move over the row with the auto number the same as it was on the original sheet?
Thanks!
Best Answer
-
Ray Lindstrom ✭✭✭✭✭✭
As long as your destination sheet doesn't have the numbering column setup as an Auto Number, you should be fine. In your destination sheet, keep the numbering column as a "Text/Number" column instead.
BRgds,
-Ray
Answers
-
Ray Lindstrom ✭✭✭✭✭✭
As long as your destination sheet doesn't have the numbering column setup as an Auto Number, you should be fine. In your destination sheet, keep the numbering column as a "Text/Number" column instead.
BRgds,
-Ray
-
TheoR74 ✭
ok. I'll give that a try and see how it does.
Thanks!
Categories
You would use the below for Jan 2023 and adjust the month and year numbers accordingly for each of the other months.<\/p>
=IF(AND(MONTH([Start Date]@row)<= 1, YEAR([Start Date]@row)<= 2023, MONTH([End Date]@row)>= 1, YEAR([End Date]@row)>= 2023), [$ per month]@row)<\/p>"},{"commentID":387901,"body":"
Lets try a different approach.<\/p>
=IF(AND(VALUE(YEAR([Start Date]@row) + IF(MONTH(Start Date]@row)< 10, \"0\", \"//www.santa-greenland.com/community/discussion/107883/\") + MONTH([Start Date]@row))<= 202307<\/strong>, VALUE(YEAR([End Date]@row) + IF(MONTH([End Date]@row)< 10, \"0\", \"//www.santa-greenland.com/community/discussion/107883/\") + MONTH([End Date]@row))>= 202307<\/strong>), [$ per month]@row)<\/p> Basically we are creating a yyyymm stamp from the start and end dates and comparing them to the yyyymm stamp for that year\/month combo. The above is for July 2023 (202307).<\/p>"},{"commentID":387906,"body":"
<\/p>