![Danny_Mohill Danny_Mohill](https://community.airtable.com/legacyfs/online/avatars/2X/a/a9dc0104564f5f2463f807525c2b5ef4870c23d8.png)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 07, 2024 10:45 AM
Hi,
I have a formula that almost works. I'm trying to make my primary field a formula where it looks at "Column A" and looks at "Column B". If a there's a value in "Column A", enter that value as the primary field. If there's a value in "Column B", enter that value in the primary filed. If there's a value in both "Column A" and "Column B", combine those two values and place a "/" between the two fields. The formula I have looks like this:
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 03, 2025 12:31 PM
I don't get it. Conditions C and D are independent or they can affect each other? What kind of output you expect?
Could you please give an example? No need to expand A,B,E,F, suppose they all present or all absent
If C and D are independent, just copy the same formula with other letters and put & between them.
Possible flaw - is when you see 'all ok' and don't know - 'which all is ok" 🙂 I mean A&B both present or E&F
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 03, 2025 06:28 PM
@Alexey_Gusev I appreciate the pushback, as it helped me rephrase my question. I'm looking to provide multiple notifications for one field; existing or missing: copy (3 fields), image (1 field), and URL (1 field)
IF(
{Creative Placement} = 'Email Seasonal Trends Category 2-Column 840x630 Medium',
IF(AND({Headline/Title Copy (EN)}='',{CTA Copy (EN)}=''), 'Missing Copy: Headline & CTA',
IF(
{Creative Placement} = 'Email Seasonal Trends Category 2-Column 840x630 Medium',
IF(AND({Headline/Title Copy (EN)},{CTA Copy (EN)}=''), 'Missing Copy: CTA',
IF(
{Creative Placement} = 'Email Seasonal Trends Category 2-Column 840x630 Medium',
IF(AND({Headline/Title Copy (EN)}='',{CTA Copy (EN)}), 'Missing Copy: Headline'
)
)
)
)
)
)
AND
IF(
{Creative Placement} = 'Email Seasonal Trends Category 2-Column 840x630 Medium',
IF({English MC Link}='', 'Missing Image'
)
AND
IF(
{Creative Placement} = 'Email Seasonal Trends Category 2-Column 840x630 Medium',
IF({Full URL + Reftag}='', 'Missing URL'
)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 03, 2025 06:56 PM
Well, I added line breaks and it looks good, I think
IF({Creative Placement}='Email Seasonal Trends Category 2-Column 840x630 Medium',
IF({Headline/Title Copy (EN)}, IF({CTA Copy (EN)}='','Missing Copy: CTA'),
IF({CTA Copy (EN)}='','Missing Copy: Headline & CTA','Missing Copy: Headline')) &
IF({English MC Link}='', '\nMissing Image') &
IF({Full URL + Reftag}='', '\nMissing URL') )
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 04, 2025 10:42 AM
@Alexey_Gusev This is next level! Thank you so much!!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 06, 2025 03:14 PM
@Alexey_Gusev one last question, is there a way to separate the responses with a ',' or ';' vs. a line break?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 07, 2025 10:40 AM - edited ‎Feb 07, 2025 10:42 AM
That's strange, but I never met such simple thing.
Maybe better solution exists. I would add ";" in the end of each text output except last
then remove possible trailing ';' in the end by wrapping whole formula in a such way:
REGEX_REPLACE(
...
whole formula
...
';$','')
Of course, line breaks '\n' should be removed
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 07, 2025 01:01 PM
@Alexey_Gusev so this?
REGEX_REPLACE(
IF({Creative Placement}='Email Seasonal Trends Category 2-Column 840x630 Medium',
IF({Headline/Title Copy (EN)}, IF({CTA Copy (EN)}='','Missing Copy: CTA;'),
IF({CTA Copy (EN)}='','Missing Copy: Headline & CTA;','Missing Copy: Headline;')) &
IF({English MC Link}='', '\nMissing Image;') &
IF({Full URL + Reftag}='', '\nMissing URL') ) ';$','')
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 09, 2025 06:46 PM
'\nMissing Image;') &
IF({Full URL + Reftag}='', '\nMissing URL') ) ';$',''
![](/skins/images/75AB00B4920FD2D67A8CABF77C9DECC4/responsive_peak/images/icon_anonymous_message.png)
- « Previous
-
- 1
- 2
- Next »