Help

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.

Get an status triggered by different fields

Topic Labels: Formulas
Solved
Jump to Solution
1287 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Mikecintosh
4 - Data Explorer
4 - Data Explorer

Hi Community, 

I have 5 fields (checkbox) that can be selected or not, I need to assign a status triggered by these fields, if any field of the 5 is selected then a status will be set and if no one is selected It will assign a different status.

Screenshot 2023-03-14 at 19.11.23.png

 

Thanks for the help.

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

Try something like:

IF(
  OR(
    {Route 1 Under Testing},
    {Route 2 Under Testing}
  ),
  "Testing"
)

Screen Recording 2023-03-15 at 10.22.39 AM.gif

Link to base

See Solution in Thread

2 Replies 2
TheTimeSavingCo
18 - Pluto
18 - Pluto

Try something like:

IF(
  OR(
    {Route 1 Under Testing},
    {Route 2 Under Testing}
  ),
  "Testing"
)

Screen Recording 2023-03-15 at 10.22.39 AM.gif

Link to base

@TheTimeSavingCo  Amazing. 

Thanks a lot.