Quote:
Originally Posted by jollyhumper
This one I don't really get. (Remember, I seriously suck at spreadsheets. It's math, y know...)
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?
|
This ain't math
Let's say you have 10 galleries & you want to schedule 1 for every other day. On the
example I posted where the date is 2018-02-14 00:00:00, click the cell below the date. Then:
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:
Originally Posted by jollyhumper
So if I get this correctly, when I import a preview-url, I can get the scanner to crop that image. (in other words, scanner will not try to import from gallery-url (and often get a 302)?
|
No. That's what I hoped it'd do. The only way you can import thumbs is if the Preview URL is the size of the thumb you want to use. Otherwise, what I do after I import is search the galleries & check the Thumbs No Preview box. Then I go to each gallery, save an image to use for the thumb, and import/crop it by clicking the green up arrow
under where the thumb would be displayed.
Hope all that is clear enough for your math deprived brain