Forum Discussion

JackWoods's avatar
JackWoods
Qrew Trainee
5 years ago

Formula Field to display the value of another field

Hey How goes it - I want to be able to display the Project Manager Twice on the same Form and I can't see to figure it out. I thought I would put together a formula field to do it but I keep getting a...
Formulas and functions
JackWoods's avatar
JackWoods
Qrew Trainee
5 years ago
that didn't work either. Thanks. 

It tried doing it with another field to see if the look up to the user table was causing the issue but that didn't work either. 

He is another example - I would like to do the same for Status. so be able to show the status field twice on the same form.

If(isNull([Status])," ",[Status])

------------------------------
Jack Woods
------------------------------
LisaSell1's avatar
LisaSell1
Qrew Trainee
5 years ago
Try this - if it isn't blank, you will get the Project Manager repeated
If([Project Manager]=" "," ",[Project Manager])

------------------------------
Lisa Sell
------------------------------
  • JackWoods's avatar
    JackWoods
    Qrew Trainee
    5 years ago
    Thank you - this worked for the status field but not for the Project Manager field. 

    If([Project Manager]=" "," ",[Project Manager])

    I used a look up summary field for the project manager instead of a formula field.

    I'm all set now.

    ------------------------------
    Jack Woods
    ------------------------------
    • BlakeHarrison's avatar
      BlakeHarrison
      Qrew Captain
      5 years ago
      If the [Project Manager] field is a User field, you would need to first convert it to Text in order for the formula to evaluate correctly:

      If(UserToName([Project Manager])=" "," ",[Project Manager])

      Also, if it is a User field, be sure that your formula field is a Formula User field as well.

      ------------------------------
      Blake Harrison
      bharrison@datablender.io
      DataBlender - Quick Base Solution Provider
      Atlanta GA
      404.800.1702 / http://datablender.io/
      ------------------------------