Continued thread
For #AppleNumbers: `=LET(y,2025,d,DATE(y,1,1),SEQUENCE(DUR2DAYS(DATE(y+1,1,1)-d),,d))`
Administered by:
#AppleNumbers
0 posts0 participants0 posts today
Numbers app 쓰다가 `REGEX`랑 `REGEX.EXTRACT` function이 있단 걸 알았어요. 언제 생긴 거지? #AppleNumbers
Consider revamping your budgeting system with Apple numbers and Apple shortcuts and set up some saving goals before #WWDC motivates you to spend some money again 
youtu.be- YouTubeEnjoy the videos and music you love, upload original content, and share it all with friends, family, and the world on YouTube.
It is incredibly inconvenient to do whole row conditional formatting in #AppleNumbers.
Really should be able to conditionally highlight a cell based on onther cells’ contents as well as its own. In numbers you have to set up proxy columns to achieve the effect.
If you’re a fan of @jsnell's Six Colors charts on Apple’s earnings, you’ll love this episode of Chit Chat Across the Pond where I get him to tell me how he makes the magic. It’s full of nerdy fun like how he decides when to use a serape chart vs. a bar chart, how he calculates a rolling average, how he gets the data for the charts, and how he gets the charts from Apple Numbers into his website.
Podfeet Podcasts · CCATP #808 — Jason Snell on The Magic Behind the Six Colors Charts - Podfeet PodcastsIf you’ve been on the Internet before, and you’ve heard of a little fruit company called Apple, then you’ve probably seen Jason Snell’s famous Six Colors charts on Apple earnings. In this episode of Chit Chat Across the Pond, we don’t talk about earnings, we talk about the magic behind how he creates his famous […]
TIL Table Categories in Numbers + Running total columns do not work well.
Decided to turn categories off and use a filter instead to hide transactions older than 6 months. #AppleNumbers
Freeze your header rows in Apple Numbers to leave column headers fixed. This'll help you avoid forgetting what each column represents. #iWork #AppleNumbers #Numbers #Spreadsheets
https://iworkexpert.com/freeze-header-rows-in-apple-numbers/
iWork Expert · Freeze Header Rows in Apple Numbers | iWork ExpertFreeze your header rows in Apple Numbers to leave column headers fixed. This'll help you avoid forgetting what each column represents.
It's very annoying that formatting isn't applied to new rows/columns added to pivot tables in Numbers after refreshing the data…
Replied in thread
@dm @libreoffice so mach ich’s auch, nur mit #AppleNumbers statt LibreOffice. Falls du mal reinschauen willst: https://github.com/tweh/lehrerwerkzeuge
GitHubGitHub - tweh/lehrerwerkzeuge: Sammlung von Dateien und Skripten zur Unterrichtsvorbereitung etc.Sammlung von Dateien und Skripten zur Unterrichtsvorbereitung etc. - tweh/lehrerwerkzeuge
ɐıunp zsɐɯoʇ 
Do you know what is the worst thing about #AppleNumbers? The fact that when I have Polish set as the system language, Numbers translates the functions (interestingly not all of them...), but all the tutorials on the Internet contain English function names....
Wiecie co w #AppleNumbers jest najgorsze? To, że jak mam ustawiony polski jako język systemowy to Numbers tłumaczy mi funkcje (co ciekawe nie wszystkie...), a wszystkie poradniki w internecie zawierają angielskie nazwy funkcji...
There is a really easy way to export Apple #Contacts into an #AppleNumbers #Spreadsheet. If you have a ton of contacts and need a good way to siphon some information, read on to learn how this can be done. Plus, avoid pitfalls easily in my post. #iWork
https://iworkexpert.com/export-apple-contacts-into-an-apple-numbers-spreadsheet/
iWork Expert · Easily Export Apple Contacts into an Apple Numbers Spreadsheet - iWork ExpertThere is a really easy way to export Apple Contacts into an Apple Numbers Spreadsheet. You may want to do this for various reasons. Keep reading to learn how.
Need a free #SuperBowlSquares #template for #AppleNumbers for the upcoming #SuperBowl? You're in luck. We have a free template you can download and use for your upcoming party. No prior #spreadsheet knowledge required.
https://iworkexpert.com/super-bowl-squares-template-for-apple-numbers/
iWork Expert · Free 2024 Super Bowl Squares Template for Apple Numbers - iWork ExpertNeed a free Super Bowl squares template for Apple Numbers for the upcoming Super Bowl? You're in luck. We have a free template you can download and use for your upcoming party. No prior spreadsheet knowledge required.
Have a #spreadsheet where you wish you could remove hyperlinks in #AppleNumbers? Let me show you how to use this 1 function that can do just that.
iWork Expert · Effortlessly Remove Hyperlinks in Apple Numbers Using this 1 Function - iWork ExpertHave a spreadsheet where you wish you could remove hyperlinks in Apple Numbers? Let me show you how to use this 1 function that can do just that.
Need to sum values based on criteria? You're in luck. The 2 best functions to accomplish this will be SUMIF and SUMIFS. Learn how you can use these powerful functions in your #spreadsheet formulas to simplify calculations. #iWork #AppleNumbers
iWork Expert · The 2 Best Ways to Sum Values Based on Criteria Using Apple Numbers - iWork ExpertNeed to sum values based on criteria? You're in luck. The 2 best functions to accomplish this will be the SUMIF and SUMIFS. Learn how you can use these powerful functions in your spreadsheet formulas to simplify calculations.
Using a sum formula that totals to zero in your #spreadsheet? No, your computer is not broken, but there is a reason that's happening. Learn how to fix this issue each and every time in #AppleNumbers. #iWork #iWorkExpert
https://iworkexpert.com/how-to-fix-sum-formula-that-totals-to-zero/
iWork Expert · How to Fix a Pesky SUM Formula That Totals to Zero in Apple Numbers - iWork ExpertUsing a sum formula that totals to zero? No, your computer is not broken, but there is a reason that's happening. Learn how to fix this issue each and every time.
The DATEVALUE function is the perfect example of #spreadsheet compatibility between #AppleNumbers and #Excel. Find out what you need to do with your spreadsheet when coming across this function.
https://iworkexpert.com/the-datevalue-function-in-apple-numbers-explained/
iWork Expert · The DATEVALUE Function in Apple Numbers Explained and the 1 and Only Reason You’d Ever Need It - iWork ExpertThe DATEVALUE function in Apple Numbers is the perfect example of function compatibility from Excel. Find out what you need to do with your spreadsheet when coming across this function.
How long? When? With DATEDIF function in #AppleNumbers, you’ll be able to precisely track how many years, months, and days between any two dates. Read more about this underrated #spreadsheet function #iWork #iWorkExpert
https://iworkexpert.com/the-datedif-function-in-apple-numbers-explained/
iWork Expert · The DATEDIF Function in Apple Numbers Explained Plus The 1 Practical Use For It - iWork ExpertHow many months until your customers reach their next loyalty tier? How long has each employee been working at the company? With DATEDIF, you’ll be able to precisely track how many years, months, and days between any two dates. The Datedif function in Apple Numbers Explained.
The DATE function in #AppleNumbers is a great way to have dates interpreted consistently on your spreadsheet, regardless of your Time & Date settings on your computer. You may be surprised at how useful such a function can be. #iWork #iWorkExpert
https://iworkexpert.com/the-date-function-in-apple-numbers-explained/
iWork Expert · The DATE Function in Apple Numbers Explained Plus 2 Clear Use For It - iWork ExpertThe DATE function in Apple Numbers is a great way to have dates interpreted consistently on your spreadsheet, regardless of your Time & Date settings on your computer. While this may sound unimportant, you may be surprised at how useful such a function can be. Spreadsheets don’t always interpret what we see as a date…as a date.
Need a budget? In #AppleNumbers, you can use the prebuilt simple budget template. I'll show you how to best utilize this template to get the most out of it. #iWork #iWorkExpert
https://iworkexpert.com/how-to-utilize-the-simple-budget-template-in-apple-numbers/
iWork Expert · How to Best Utilize the Simple Budget Template in Apple Numbers - iWork ExpertThe simple budget template is a good way to start tracking your income and expenses. It's prebuilt and ready to go "out of the box". Let's take a closer look at how best to use this template.
Do you know how easy it is to extract text from cells in #AppleNumbers? Don't drive yourself crazy doing it manually. Learn what functions you can use to have it automatically.
https://iworkexpert.com/extract-text-from-cells-using-these-3-functions/
iWork Expert · Extract Text from Cells with Ease Using These 3 Simple Functions - iWork ExpertYou have a spreadsheet that contains data that you need to extract from individuals cells. Sounds simple enough, but how can you do it. In this post, I'll show you 3 fucnitons that can accomplish just that.