The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
I’m trying to figure out this formula, which I based on a different formula that I got to work successfully, but am hitting a wall.
Basically, I want the formula to reference 4 date fields (Edit Start, Format Start, Production Date/Time, and Ship Dat...
I had a functional formula formerly from a template, and then I went and copied tables between bases, and lost the actual formula in the field. What I’m trying to recreate is a conditional formula that returns a status on character count based on the...
I’m trying to create a field (Bulletins) that will return one of three values, based on the presence of one of three phrases in a record’s long text field. Basically:
If Comments contains Advance Notice, then populate Bulletins field with Advance Not...
I’ve tried cobbling together a fix from many other related responses, but nothing’s worked, so here’s my conundrum. I have to schedule social media posts, but I designate one day a week (Friday), to draft/schedule all the posts that will be going liv...
Jeremy_Oglesby:
{Marketing Lead} &
{Graphics Lead} &
{Media Production Lead} &
{Editorial Lead} &
{Formatting Lead} &
{Production Lead}
WOW. What a brilliantly simple answer. Works like a charm!
The fields are Collaborator fields. They’re for assignments (so I should correct my field titles, they’re actually Marketing Lead, Graphics Lead, Media Production Lead, Editorial Lead, Formatting Lead, and Production Lead)
There will always, only, ev...
@Jeremy_Oglesby Another If/Concatenate conundrum for you!
I have fields for each of 6 teams (Marketing, Graphics, Media Production, Editorial, Formatting, and Production) that I am trying to concatenate with a single other field (Document/Project Tit...