This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hello everyone !
I have records with multiples Date fields (4 fields to be exactly). So we have {date field 1},{date field 2},{date field 3} and {date field 4}.
I would like to have a formula field that shows only the year of one of these date field....
Hello the community !
I have a table with a date field. I have a formula which is :
IF(IS_AFTER(TODAY(),{Date}), ‘Published :rocket: ’, ‘To publish :hourglass_flowing_sand: ’)
And it’s working fine.
Now, I have 3 différent dates for 1 record. So I ...
This is very interesting, thank you. I will try to look at integromat for possible solutions. I’m curious :grinning_face_with_big_eyes:
I’ll be sure to come back to you both if I need to.
After somes researches and tests, I’ve got a formula that works.
IF({Date 1}=BLANK(),IF({Date 2}=BLANK(),IF({Date 3}=BLANK(),IF({Date 4}=BLANK()," ",DATETIME_FORMAT({Date 4},'YYYY')),DATETIME_FORMAT({Date 3},'YYYY')),DATETIME_FORMAT({Date 2},'YYYY'))...
Oh my god, thank you so much ! It’w working !
And one detail, if I want an empty cell when all date field are empty, what I suppose to write in the formula ?
