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...
