Skip to main content

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?

Something like this?


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

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?

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}

)

Does this do what you want?


{WO#} &

' - ' &

IF(

   {Status} = "Recall",

   {Status},

   {Type}

)

Yes, thank you, Jeremy!

Reply


Terms & Conditions