Help

Re: Stuck - Formula for OR

1549 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Holli_Younger
8 - Airtable Astronomer
8 - Airtable Astronomer

I can’t find a similar question so I’m reaching out.

My placeholder shows Project - “our tracking number” but I need to have “project” changed to Recall ONLY IF a dropdown menu has the status of Recall.

Suggestions on the OR formula to use?

4 Replies 4
FullCircleFoods
6 - Interface Innovator
6 - Interface Innovator

Something like this?

IF({Status} = 'Recall', 'Project' & '-' & {Tracking Number}, 'Recall' & '-' & {Tracking Number})

This is pretty close, but I am trying to put this formula together where it makes sense.

Currently my formula is {WO#} & ’ - ’ & {Type} it pulls our tracking number and the type which is automatically listed as Project. However, I had to add another dropdown menu for recalls, which I need the formula to keep {WO#}& ’ - ’ & [[[ ]]] change type to Recall if that is selected from the dropdown.

Does this make sense?

Does this do what you want?

{WO#} &
' - ' &
IF(
   {Status} = "Recall",
   {Status},
   {Type}
)

Yes, thank you, Jeremy!