momentsgoneby80 - profile

momentsgoneby80 · Jul 21, 2022

Hi! I’ ve encountered a possible Airtable quirk and was wondering if anyone has a hint how to work around it. I have a Long Text Field with RTF enabled. In this field I have RTF formated text / Markdown text. In a formula field I’m trying to search t...

momentsgoneby80 · Jul 21, 2022

Hi! I have a base with quite a bit of Korean names in it. As the names often have a few different ways of romanization I have a field for alternative romanized spellings; {Alternative Spelling(-s)}. What complicates it further is that each romaizatio...

momentsgoneby80 · Mar 22, 2021

Hi! I have a base for fanfic that imports data and chapters via Airtables Webclipper. Some fanfics have 100+ chapters, so my base is set up to accomodate up to 125 chapters, one per field. After a fanfic is imported I want to tagg it for the characte...

momentsgoneby80 · Apr 05, 2020

Hi! I have a formula that works awesomly to calculate international age (see below). IF( { Birthday}=BLANK(), ' (N/A)', IF( { Death}=BLANK(), IF({ Birthday},' ('&DATETIME_DIFF(TODAY(), { Birthday}, 'years')&')'), IF({...

momentsgoneby80 · Mar 31, 2020

Hi! I’m one of those that like organizing and solving things, but is horrid at learning things strictly through textbooks and other textbased material. I learn best through application and therfore have a base where I try all kinds of things for the ...

momentsgoneby80 · Jul 21, 2022

Hi @Adam_TheTimeSavingCo! Nope, not the Korean messing it up. I copied your base and added the Korean and it works just fine. But in my base it just doesn’t. If I copy straight from my base to yours, yours doesn’t work for that new record either. The...

momentsgoneby80 · Jun 12, 2022

Hi and welcome @TF_UNOC! You’re on the right track. The issue is that DATETIME_DIFF() formula returns whole integers for any unit specifier, so simply trying to use a round up or similar won’t work. What we can do is use the time difference in a calc...

momentsgoneby80 · Jun 11, 2022

Hi and welcome @Joan_Born! This should work for you IF( {Date field}, DATEADD(DATEADD({Date field},-2,'weeks'),4-WEEKDAY({Date field}),'days') )

momentsgoneby80 · Jun 09, 2022

That’s great that you found a solution. When checking the same field for multiple values in a formula you can use a SWITCH() function instead. This assumes you have a {Status} field and a {Name of Task} field. You can use this right away in the prima...

momentsgoneby80 · Jun 09, 2022

Hi and welcome @Svenja_Rossig! The formula you mentioned should work as is, but is of course dependant on how you determine a task completed or not. The mentioned formula only conciders if {Completed} has ANY value, not what that value might be. If y...

User Statistics

User Activity

How do you FIND() or REGEX_MATCH() in a RTF Long text field?

Formula for alternative spellings and formating of names

Is it possible to condense this huge and clunky formula in any way?

Calculating Korean age

IF formula for Zodiac sign and Chinese Zodiac

Re: How do you FIND() or REGEX_MATCH() in a RTF Long text field?

Re: Calculation difference between dates ignoring the time of day

Re: Assign a due date of Thursday for all items due in a certain week

Re: How to show which tasks are completed and which open in linked column?

Re: How to show which tasks are completed and which open in linked column?