Help

Get an status triggered by different fields

Topic Labels: Formulas
Solved
Jump to Solution
1178 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.