Oct 18, 2019 09:03 AM
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?
Oct 18, 2019 09:27 AM
Something like this?
IF({Status} = 'Recall', 'Project' & '-' & {Tracking Number}, 'Recall' & '-' & {Tracking Number})
Oct 18, 2019 09:43 AM
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?
Oct 18, 2019 10:12 AM
Does this do what you want?
{WO#} &
' - ' &
IF(
{Status} = "Recall",
{Status},
{Type}
)
Oct 18, 2019 10:45 AM
Yes, thank you, Jeremy!