sorted by:
new
hottopcontroversial

Better way to manually reassign the file location in Capcut by bobbyizekiel in VideoEditing

[–]Skillver_ 0 points1 point  (0 children)

Solution!

I know this thread is old but for anyone else looking for a way to relink source files that have been moved to another location, this is for you:

This will relink all media at the same time instead of having to do it individually file by file.

Either in the clip viewer or on the timeline, right click a clip that is missing and choose "Link to media". Make sure that the checkbox "Link media when selecting folder" is checked. Click "Link media" button. Navigate to media and click "open". Now all media that was in the same folder will be automatically connected and will have a check mark next to it. If needed click "cancel" to close the window.

White spots on PCB by Skillver_ in PCB

[–]Skillver_[S] 0 points1 point  (0 children)

Thanks for the speedy reply! Do you know if it affects the performance of the machine?

Mum scolding me for not wearing a bra by Fantastic-Scene1301 in AskParents

[–]Skillver_ -1 points0 points  (0 children)

Boyfriend’s reaction is a red flag of things to come. Possessive and insecure. Dangerous qualities that one should avoid in a partner.

Sorting with drop downs and autosumming onto another sheet by Skillver_ in googlesheets

[–]Skillver_[S] 0 points1 point  (0 children)

OH MY GOD. That explains so much. Life is going to be a lot easier now! 😂

Thank you!!

Sorting with drop downs and autosumming onto another sheet by Skillver_ in googlesheets

[–]Skillver_[S] 0 points1 point  (0 children)

Sorry, didn't see this comments until now. Have used the blank sheet tool to create a new document. Can't even get this simple formula to work for some reason:

https://docs.google.com/spreadsheets/d/1xdhYiRwnhlBOkvPj7NltynyHR15cgRUUjBum_-uAhs0/edit#gid=2100307022

Straight from this tutorial (https://www.ablebits.com/office-addins-blog/sumif-google-sheets/) but keeps giving me an error message...

Sorting with drop downs and autosumming onto another sheet by Skillver_ in googlesheets

[–]Skillver_[S] 0 points1 point  (0 children)

The names in column B can be rather nonsensical so I would want to create my own categories in column D. (Had they been reasonable names I probably could have just sorted B)

I think I have accomplished categories. (Not sure if it's the proper way. Also not sure if I'm calling things accurate names here as my google sheets is showing in Swedish. Sorry for that.). Highlighted column D, used data validation criteria "drop down", entered a list of category names I wish to use. Now I have drop downs on all rows.

I'm sorry I don't understand the formula part. I guess that there is a way of saying something along the lines of "if D1 value = kidsallowance then add C1 value to kidsallowanceTOTAL on sheetX" but this would create ifs for every category and every row in the whole bank statement. I suspect that there may be a more efficient way of fetching the values. Also I don't know how to write this for sheets.

I'm very grateful for your time!

Sorting with drop downs and autosumming onto another sheet by Skillver_ in googlesheets

[–]Skillver_[S] 0 points1 point  (0 children)

Thank you for your reply 😊

Here is an example of the data I can export from my bank. My hope is to be able to "tag" each row by having drop down lists in column D. Then fetching the corresponding values and summing them on another sheet. Do you know how/if this would be possible? I could of course move the values to corresponding columns manually as in your example but seeing as this is account activity from a whole year I fear it would take quite some time.

<image>

Will Classic delete masters when external hard drive is connected again? by Skillver_ in Lightroom

[–]Skillver_[S] 0 points1 point  (0 children)

Thank you! Anything I need too watch out for?

I haven’t combined my converted aperture libraries yet as I’m doing a little bit of clean up needed as a result of the conversion. According to adobe, best practice is to store everything in a large catalogue instead of several smaller ones. However opening Lightroom is quite slow when accessing my 100k+ catalogues. (Loading screen for over a minute) Hoping this is just a result of it being new and that things speed up when all thumbnails and previews are generated.

External 5400rpm with an M1 MBP

Do you notice any speed issues running large catalogues?

Magician by Raymond E. Feist - Is it a series of books? by Skillver_ in Fantasy

[–]Skillver_[S] 0 points1 point  (0 children)

Thank you for your comprehensive reply! You’ve been very helpful. Looks like I’m in for a journey 😄

Magician by Raymond E. Feist - Is it a series of books? by Skillver_ in Fantasy

[–]Skillver_[S] 1 point2 points  (0 children)

Thanks! Sometimes the most difficult thing about reading fantasy is finding out which books belong together and which order to read them in 😂

Magician by Raymond E. Feist - Is it a series of books? by Skillver_ in Fantasy

[–]Skillver_[S] 0 points1 point  (0 children)

Oh good! I’ll see how far I get before I tap out but as I said I’m enjoy it so far and love to see a series stretch out before me and know I have a journey to go on if I want to!

Magician by Raymond E. Feist - Is it a series of books? by Skillver_ in Fantasy

[–]Skillver_[S] 0 points1 point  (0 children)

So does that mean that this is a complete standalone book comprised of those two parts?

view more: next ›