Forum Discussion

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

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
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
  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
    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
    ------------------------------