locked
URL Filter, String with Numbers and Text RRS feed

  • Question

  • Need help filtering a task list on a string column with information like this A100.

    The usual FilterField1=Column Name&FilterValue1=A100 Does not work because it has numbers in the field. I can make it work if a create a concatenated calculated column to format A100 to -A100-. Formula Looks like this: =CONCATENATE("-",[Project Number],"-")

    Is there another way to use the URL filter with out having to create a calculated field?

    Thanks

    Sunday, July 31, 2016 10:50 PM