Hi
Part of my report displays an Assignee's name, however if a job as been assigned to a team but not yet assigned to a team member, it displays nothing.
Any suggestions where/how to write a formula that replaces blanks with a custom string such as "Not yet assigned" ?
Much appreciated
ThanksHi
Part of my report displays an Assignee's name, however if a job as been assigned to a team but not yet assigned to a team member, it displays nothing.
Any suggestions where/how to write a formula that replaces blanks with a custom string such as "Not yet assigned" ?
Much appreciated
Thanks
I've done this a couple ways.
Method 1: insert the text object "Not yet assigned" in the same place as the Assignee's name. Format the Assignee field with a white background.
Method 2: prepare a formula @.assignee. if isnull({assigneefield}) then "Not assigned yet" else {assigneefield}
Tuesday, March 20, 2012
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment