Requested by Who field isn't working | Community
Skip to main content
J
JillAc
Level 10
June 8, 2022
Question

Requested by Who field isn't working

  • June 8, 2022
  • 1 reply
  • 1112 views

I have a request field that is one that I believe came with WF that I didn't build. It is a calculation "Requested by Who?" and has a formula that works on all my request object forms except one. When I add the field to this wonky form the calculation part isn't populated, so I put the formula in "additional settings", the same way it is on the other request forms, and I get an error. What am I doing wrong?

Formula: IF(ISBLANK({Requested By Who?}),Entered By.Name,{Requested By Who?})

Error: Requested By Who? field is used in a multi-form configuration, if you would like to change this formula you will need to remove this field and replace it with a new one containing the desired calculation.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

skyehansen
Community Advisor
skyehansenCommunity Advisor
June 8, 2022

I recommend you read this help article.

https://one.workfront.com/s/document-item?bundleId=the-new-workfront-experience&topicId=Content%2FAdministration_and_Setup%2FTips_Tricks_and_Troubleshooting%2Ferror-message-field-used-in-multi-form-config.html&_LANG=enus

Aside from this, I can add that the additional settings area is pretty finicky, especially when you have multiple forms attached to an object and all of them are using this calculated field. Like, just having an additional space at the beginning or end of the calculation can cause it to be "not identical"

    J
    JillAcAuthor
    Level 10
    June 8, 2022
    I started to read that and my brain completely shut down. I’m going to have to set aside an entire day to understand this.
    skyehansen
    Community Advisor
    skyehansenCommunity Advisor
    June 9, 2022

    I feel you! Let's just say the summary of the page is that Workfront thinks that one of your formulas is not like the others. It might be off by as little as a space. But it's off. Sometimes the only way to get around that is to delete the calculated field off all the custom forms, save and close all the forms, and then put the field back in one at a time -- copying and pasting the same way to each. The help article gives you shortcuts to determining where the conflicts might be so that you can avoid doing them all, but that's entirely up to you.

    Frankly, if you are going to go this route, the only thing I would do is change the "requested by who?" field name to remove the question mark (and update your formula to match). Special characters are horrible to deal with in field names -- you can leave it in the label so that your users don't complain, but this will save you some heartache in the future. But this suggestion is only if you end up removing the calculated fields from all the forms.

    Terms & ConditionsAccessibility statement

    Loading footer...