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?
Stuck - Formula for OR
+4
+5Something like this?
IF({Status} = 'Recall', 'Project' & '-' & {Tracking Number}, 'Recall' & '-' & {Tracking Number})
+4Something 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}
)
+4Does this do what you want?
{WO#} &
' - ' &
IF(
{Status} = "Recall",
{Status},
{Type}
)
Yes, thank you, Jeremy!
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.