You mean something like
IF ( [Kan laves d.] = [calculation of next wednesday], 🟢, "")
?
You mean something like
IF ( [Kan laves d.] = [calculation of next wednesday], 🟢, "")
?
Exactly!
I tried with this one:
IF(
AND(
IS_AFTER({Kan laves d.}, TODAY()),
WEEKDAY({Kan laves d.}) = 3,
WEEKDAY(TODAY()) <> 3
),
"🟢",
BLANK()
)
But Airtable won't accept that for some reason.
I think this should do the trick:
IF({Kan laves d.},IF(DATETIME_FORMAT(DATEADD(TODAY(), IF(WEEKDAY(TODAY())<=3, 3-WEEKDAY(TODAY()), 10-WEEKDAY(TODAY())), 'days'), 'DD/MM/YYYY')={Kan laves d.},"🟢",""),"")
I think this should do the trick:
IF({Kan laves d.},IF(DATETIME_FORMAT(DATEADD(TODAY(), IF(WEEKDAY(TODAY())<=3, 3-WEEKDAY(TODAY()), 10-WEEKDAY(TODAY())), 'days'), 'DD/MM/YYYY')={Kan laves d.},"🟢",""),"")
Hi Mariusz_S
So this time it accepted the formula - nice!
However no input appears in the field afterward.
Please se attached picture (the blank field all the way to the right is the formula field with your formula.
BUT I actually just realised that something is wrong with the first formula too since the 25/2/23 isn't the next coming wednesday, but a saturday.. Hm. Can you see where the error is?
DATETIME_FORMAT(
IF(
DAY({Tilføjet d.}) <= 10,
DATETIME_PARSE(CONCATENATE(YEAR({Tilføjet d.}), '-', MONTH({Tilføjet d.}), '-11'), 'YYYY-MM-DD'),
DATEADD({Tilføjet d.}, IF(WEEKDAY({Tilføjet d.}) <= 3, 3 - WEEKDAY({Tilføjet d.}), 10 - WEEKDAY({Tilføjet d.}) + 3), 'day')
),
'DD/MM/YYYY'
)
A little side note: The formula is made (or at least that's the plan) to nok make use of the first 10 days of the month since we won't make payments in that period, only after the first 10 days.
Hi Mariusz_S
So this time it accepted the formula - nice!
However no input appears in the field afterward.
Please se attached picture (the blank field all the way to the right is the formula field with your formula.
BUT I actually just realised that something is wrong with the first formula too since the 25/2/23 isn't the next coming wednesday, but a saturday.. Hm. Can you see where the error is?
DATETIME_FORMAT(
IF(
DAY({Tilføjet d.}) <= 10,
DATETIME_PARSE(CONCATENATE(YEAR({Tilføjet d.}), '-', MONTH({Tilføjet d.}), '-11'), 'YYYY-MM-DD'),
DATEADD({Tilføjet d.}, IF(WEEKDAY({Tilføjet d.}) <= 3, 3 - WEEKDAY({Tilføjet d.}), 10 - WEEKDAY({Tilføjet d.}) + 3), 'day')
),
'DD/MM/YYYY'
)
A little side note: The formula is made (or at least that's the plan) to nok make use of the first 10 days of the month since we won't make payments in that period, only after the first 10 days.
I think your original formula (stored on "Kan laves d.") might have an error. Can you try the one below and report back?
DATETIME_FORMAT(DATEADD({Tilføjet d.}, IF(WEEKDAY({Tilføjet d.})<=3, 3-WEEKDAY({Tilføjet d.}), 10-WEEKDAY({Tilføjet d.})), 'days'), 'YYYY-MM-DD')
I think your original formula (stored on "Kan laves d.") might have an error. Can you try the one below and report back?
DATETIME_FORMAT(DATEADD({Tilføjet d.}, IF(WEEKDAY({Tilføjet d.})<=3, 3-WEEKDAY({Tilføjet d.}), 10-WEEKDAY({Tilføjet d.})), 'days'), 'YYYY-MM-DD')
That formula worked like a charm. Now it shows 22/2/23!
However the other formula still shows a blank field (see image).
That formula worked like a charm. Now it shows 22/2/23!
However the other formula still shows a blank field (see image).
Ah there was a mistake in the date format.
"Kan laves d." :
DATETIME_FORMAT(DATEADD({Tilføjet d.}, IF(WEEKDAY({Tilføjet d.})<=3, 3-WEEKDAY({Tilføjet d.}), 10-WEEKDAY({Tilføjet d.})), 'days'), 'DD/MM/YYYY')
🟢 formula field:
IF({Following WED Date},IF(DATETIME_FORMAT(DATEADD(TODAY(), IF(WEEKDAY(TODAY())<=3, 3-WEEKDAY(TODAY()), 10-WEEKDAY(TODAY())), 'days'), 'DD/MM/YYYY')={Following WED Date},"🟢",""),"")
Mariusz! Thanks a lot. I am very grateful for your help with this. Thanks!