Forum Discussion

CurtisMiddleton's avatar
CurtisMiddleton
Qrew Trainee
6 years ago
Solved

Formula Not Functioning as Expected

Hi, Can someone please help me with the following formula. I have comments under each line as to what it should be doing, but it is not doing that. It is just displaying zero. If([Spent By]=ToUs...
Formulas and functions
  • EverettPatterso's avatar
    EverettPatterso
    6 years ago
    Try this one

    If(UserToName([Spent By], "FF")="John Doe" and [Shared Purchase?]=true, [Amount]/2,
//If user is John Doe and Checkbox is checked, display the amount divided by two, otherwise execute next if statement.

UserToName([Spent By], "FF")!="John Doe" and [Shared Purchase?]=true, [Amount]/2,
//If user is not John Doe and Checkbox is checked, display the amount divided by two, otherwise execute next if statement.

UserToName([Spent By], "FF")!="John Doe" and [Shared Purchase?]=false, [Amount], 0)
//If user is John Doe and Checkbox is NOT checked, display the amount, otherwise display 0.​


    ------------------------------
    Everett Patterson
    ------------------------------
EverettPatterso's avatar
EverettPatterso
Qrew Captain
6 years ago
Try this one

If(UserToName([Spent By], "FF")="John Doe" and [Shared Purchase?]=true, [Amount]/2,
//If user is John Doe and Checkbox is checked, display the amount divided by two, otherwise execute next if statement.

UserToName([Spent By], "FF")!="John Doe" and [Shared Purchase?]=true, [Amount]/2,
//If user is not John Doe and Checkbox is checked, display the amount divided by two, otherwise execute next if statement.

UserToName([Spent By], "FF")!="John Doe" and [Shared Purchase?]=false, [Amount], 0)
//If user is John Doe and Checkbox is NOT checked, display the amount, otherwise display 0.​


------------------------------
Everett Patterson
------------------------------
  • BabiPanjikar's avatar
    BabiPanjikar
    Qrew Assistant Captain
    6 years ago
    The solution provided by Everett will work perfectly for your case. However,  basing a check on username is not the right approach as two people can have same names and will comprise your data between two users.  You should be using the below options.

    ToText(UserToEmail([Spent By])) ="email address of the person"

    OR
    [Spent By] = User()  -- Match the current logged user with the field value in spent by field to control the rights.



    ------------------------------
    Babi Panjikar
    ------------------------------