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 an error on the "IF IS NULL" statement below.

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

Please let me know if this is possible and the best way to display a field twice on one form.

Thank you!

------------------------------
Jack Woods
------------------------------
Formulas and functions
  • AlexBennett3's avatar
    AlexBennett3
    Qrew Trainee
    5 years ago
    An error with the code?

    Try capitalizing the 'n' in null. ex: If(isNull([Project Manager])," ",[Project Manager])

    ------------------------------
    Alex Bennett
    ------------------------------
    • 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
        ------------------------------