Edit: Whoops, sorry @Sho , didn't mean to post the exact same thing as you! I think I opened the tab when there were no replies and then went to look for coffee or something
Try this:
IF(
{Weekday planner},
DATETIME_FORMAT(
DATEADD(
TODAY(),
(({Auto Date 2}-(WEEKDAY(TODAY())))*24)+15,
"hours"
),
'MM/DD/YYYY h:hm A'
)
)
The DATETIME_FORMAT() function converts a date to a text string. If you want Airtable to recognize the new date as a date, omit the DATETIME_FORMAT() function.
IF(
{Weekday Planner},
DATEADD(
TODAY(),
(({Auto Date 2} - (WEEKDAY(TODAY())))*24)+15,
"hours"
)
)
It does work! I am curious about this formula you all made. Does it help that there is not an actual condition such as {weekday planner}="" ? What does it mean when it is simply If({weekday planner}, X) and there is no other option. Does it mean if it exists or is not blank?, and there's no close out for if/then, is it assumed as well?
Although not mentioned in the reference,
If only the field name is indicated in the condition, the value of the field is considered False whether it is FALSE, empty or 0.
The value of FALSE can then be omitted.
Although not mentioned in the reference,
If only the field name is indicated in the condition, the value of the field is considered False whether it is FALSE, empty or 0.
The value of FALSE can then be omitted.
Thanks, that must be common to use in coding but I'm more of an excel guy, not even VBA. I don't even format anything, I set up these conditionals linearly and read them like a sentence! I need to learn your ways.
