- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 09, 2023 03:47 AM
I can't get this formula to work.
My table has 3 fields:
- Agreement Signed
- WYNTK Signed
- Intake Form
Each field has a single select option, "Yes" , "n/a" or "In Progress".
I have a final field "STATUS" with a formula - should all three fields = "Yes" or "n/a" = "✅"
If any one of the fields = "In Progress" then the STATUS field = "❌"
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 09, 2023 05:30 AM
Could you try this out?
IF(
AND(
OR(
{Agreement Signed}="Yes",
{Agreement Signed}="n/a"
),
OR(
{WYNTK Signed}="Yes",
{WYNTK Signed}="n/a"
),
OR(
{Intake Form}="Yes",
{Intake Form}="n/a"
)
),
"✅",
"❌"
)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 09, 2023 05:30 AM
Could you try this out?
IF(
AND(
OR(
{Agreement Signed}="Yes",
{Agreement Signed}="n/a"
),
OR(
{WYNTK Signed}="Yes",
{WYNTK Signed}="n/a"
),
OR(
{Intake Form}="Yes",
{Intake Form}="n/a"
)
),
"✅",
"❌"
)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 09, 2023 01:09 PM
@TheTimeSavingCo Worked! Thank you so much! 🎉
