|
|
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
2018-02-13, 03:30 PM | #1 | |
The Original Greenguy (Est'd 1996) & AVN HOF Member - I Crop Pics For Thumbs In My Sleep
|
Quote:
The idea for the drop down came to me when I was going to sleep last night, so I'm glad that I remembered to try it as well as figuring out how worked ------- If anyone does need help with anything as far as this or any spreadsheet, just ask. While I've had no formal training with them, I'll pat myself on the back & say that I'm pretty fucking good when it comes to spreadsheets |
|
2018-06-06, 05:51 AM | #2 | ||
That's what she said
|
Quote:
How do I put that formula 'behind' the date? And, when I copy and paste the date into a new field, will it then auto-update according to formula? Quote:
Jlly |
||
2018-06-06, 06:17 AM | #3 | ||
The Original Greenguy (Est'd 1996) & AVN HOF Member - I Crop Pics For Thumbs In My Sleep
|
Quote:
1 - Type = on your keyboard 2 - Click the cell above it with the date 3 - Type + and then the number of days you want to add to the date in the cell above it 4 - Hit Enter on your keyboard. Using my example from above where you're adding 2 days to the date, before you hit enter it'll read: =I2+2 When you hit Enter, it'll read: 2018-02-16 00:00:00 Now, right click & copy that cell with the 2018-02-16 00:00:00 date in it. Then select the next 8 cells under the date & paste. That will give you: 2018-02-14 00:00:00 2018-02-16 00:00:00 2018-02-18 00:00:00 2018-02-20 00:00:00 2018-02-22 00:00:00 2018-02-24 00:00:00 2018-02-26 00:00:00 2018-02-28 00:00:00 2018-03-02 00:00:00 2018-03-04 00:00:00 Bob's your uncle One thing to note when using formulas in spreadsheets (the "=I2+2" thing is a formula): before you sort anything, select all the (in this case 10) cells that have a date in them, then right click & copy. Then right click & select Paste Special ---> Paste Values Only. That will change the cell from being a formula to being just the date. If you're not going to sort anything, ignore all that Quote:
Hope all that is clear enough for your math deprived brain |
||
2018-06-06, 06:40 AM | #4 |
The Original Greenguy (Est'd 1996) & AVN HOF Member - I Crop Pics For Thumbs In My Sleep
|
One other thing about dates & Google Sheets: I have the properties of the cells in the Scheduled column set to be Year-Month-Date Hours:Minutes:Seconds with 2 digits for everything except the year. If you double click a cell with a date in it, a calendar will pop up where you can click a different date. Problem is it'll either remove the preceding 0 from the hours:
2018-02-14 0:00:00 Or it'll shitcan the Hours:Minutes:Seconds completely: 2018-02-14 It's fucking The way around this is to copy a cell with a date in it. Then double click the cell you want a date in & paste the date in there. Before you hit enter, edit the date by hand (try it & you'll see what I mean) You have to do this because TGPX must have the date like this: 2018-02-14 00:00:00 And it gets really confused if the date is like this: 2018-02-14 0:00:00 |
2018-06-06, 08:12 AM | #5 |
That's what she said
|
Thanks
It worked (the date thing). Cool! May I ask why you use Email, name and IP in your import? If I submit it'll go straight into the review-queue, or do you do that differently as well? Do you consider tags and keywords not important, since it's not in the sheet? Can I add and remove categories in the list, or do I also have to change something in the categories-cell so It will detect the changes I make? Thumbs, I right click the preview and downloads it. deletes the big one and reupload as you mentions (green arrow). I'm starting to get a routine on it, so it goes really fast, only thing is the strain this puts on my mouse-arm. So If there was another way... Jlly |
2018-06-06, 09:26 AM | #6 | ||||
The Original Greenguy (Est'd 1996) & AVN HOF Member - I Crop Pics For Thumbs In My Sleep
|
Come with me my friend
They're fields I was putting in when I did the submits by hand - not sure what happens when you don't import them (probably go blank - and IP isn't really important for your galleries - I assume that's in there to catch cheaters) Quote:
Quote:
Quote:
Quote:
Use your nose |
||||
|
|