Forum Discussion

DonnaTroestler's avatar
DonnaTroestler
Qrew Cadet
8 years ago

Formatting a Formula - User field for a report

Newbie here. I have created a User - Formula field called "Who" within my "Activities" table which is for reporting purposes only, where I want to display the User who created the Activity. We importe...
APIs and custom code
App builders
App home pages
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
Hmmmm, so then this field type for the formula will need to be a formula list user field type. (not sure what it is now, but if it is  a formula user field type, I do not think it will allow you to change it to a formula list user type, so you will probably have to make a new field.

If(not IsNull([Created By Id]),ToUserList([Created By Id]),  [Assign to])

The original formula, I think, was backwards.