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.
Hi, I hope this is an easy to answer question; sorry for the density of my skull!
I’m building a content scheduler for my editorial team; some stories are immediately assigned a publication date, but for others that field is still blank/TBD. As a res...
I’m an Airtable noob with what I hope is an easy-to-answer questions for someone (unlike me) who knows what they’re doing.
I’m building a content scheduler for my editorial team; it includes a view of stories sorted by week. To do that, I created a f...
Many thanks to you both. However, I’m getting an “invalid formula” message when I enter the following:
IF({PUB DATE},CONCATENATE(“Week of ”,DATETIME_FORMAT(DATEADD({PUB DATE},-DATETIME_FORMAT({PUB DATE},‘e’),‘days’),‘M/D’)))
augmented:
The way IF works is the first argument makes a boolean evaluation (true or false). It can be checking that something is =,<,>, etc or it can be checking for non-empty (and probably other things too). The second argument is what IF sho...
