ContributionsMost RecentMost LikesSolutionsRe: Is Current User Filter with User-List field? Hi Mark, When there is only a single entry, this works for me, but if there are multiple people, it can't detect the current user that is listed. Any idea why? ------------------------------ Michael Naser ------------------------------ Current user filter issue The "Current user" filter on the table report is not working if there are additional people in the user list. Is there any workaround for this? Thanks ------------------------------ Michael Naser ------------------------------ How to Change Multi-select Text (summary) to user field I am having issue creating a formula to convert Combined text Multi-select Text (summary) to a user field ! I saw Mark's post about how to change it, however it did not work for me var text value = ToText([Combined Text List-User(text format)]); ToUserList( ToUser(Trim(Part($value,1,";"))), ToUser(Trim(Part($value,2,";"))), ToUser(Trim(Part($value,3,";"))), ToUser(Trim(Part($value,4,";"))), ToUser(Trim(Part($value,5,";"))), ToUser(Trim(Part($value,6,";"))), ToUser(Trim(Part($value,7,";"))), ToUser(Trim(Part($value,8,";"))), ToUser(Trim(Part($value,9,";"))), ToUser(Trim(Part($value,10,";"))), ToUser(Trim(Part($value,11,";"))), ToUser(Trim(Part($value,12,";"))), ToUser(Trim(Part($value,13,";"))), ToUser(Trim(Part($value,14,";"))), ToUser(Trim(Part($value,15,";"))), ToUser(Trim(Part($value,16,";"))), ToUser(Trim(Part($value,17,";"))), ToUser(Trim(Part($value,18,";"))), ToUser(Trim(Part($value,19,";"))) ToUser(Trim(Part($value,20,";")))) My issue is that I receive a syntax error saying "expecting user but found user list" ------------------------------ Michael Naser ------------------------------ Report Link field issue t How to create where clause in quickbaseHi Everyone! I'm pretty much new to Quickbase so I'm having some issues in creating formulas in Quickbase! Basically the problem here is that I don't know how to create "where clauses" in Quickbase. For instance this formula works fine, but I do not know how to exculde "volunteer time sheet cost" from the calculation If ([Project - ProjID]="AD0014",([Volunteer and Training Time Sheet Cost]+),0) I would like to add following condittion so I can have the correct numbers Where the [Project classification]="Training" ------------------------------ Michael Naser ------------------------------ Adding One more condition to the formulaI have a Currency formula(This field is called Amount to Reimburse to Employee) that work perfectly fine now, however I will need to add more condition to this formula! I would like to say if [Category] equals to "Training" "Amount o Reimburse to To employee " should be 0. I tried different ways but either it does not work or return formula error! Any help would be really appreciated If([Category Requires # of 1-Way Trips Field], If([Category - Multiplied by Mileage], ([# of 1-Way Trips] * [Category Rate]) * [Resource' Commuter Miles 1-way], ([# of 1-Way Trips] * [Category Rate]) ), [Mileage Cost]+[Cost] ) ------------------------------ Michael Naser ------------------------------ Adding One more condition to the formulaI have a Currency formula(This field is called Amount to Reimburse to Employee) that work perfectly fine now, however I will need to add more condition to this formula! I would like to say if [Category] equals to "Training" "Amount o Reimburse to To employee " should be 0. I tried different ways but either it does not work or return formula error! Any help would be really appreciated If([Category Requires # of 1-Way Trips Field], If([Category - Multiplied by Mileage], ([# of 1-Way Trips] * [Category Rate]) * [Resource' Commuter Miles 1-way], ([# of 1-Way Trips] * [Category Rate]) ), [Mileage Cost]+[Cost] ) ------------------------------ Michael Naser ------------------------------ Re: Working on Nested if StatementMark! Appreciate your help! I forgot to deselect the checkbox to treat blank as zero. Everything is working properly! ------------------------------ Michael Naser ------------------------------ Re: Working on Nested if StatementSorry for the confusion! My goal is to being able to override this formula, but I would like to have the override argument an "optional" thing. Therefore, when I leave "[Reimburse amount override]" empty, I would like to have the formula work as it is. This is the original formula ( it works properly) If([Category Requires # of 1-Way Trips Field], If([Category - Multiplied by Mileage], ([# of 1-Way Trips] * [Category Rate]) * [Resource' Commuter Miles 1-way], ([# of 1-Way Trips] * [Category Rate]) ), [Mileage Cost]+[Cost] ) I created a new currency field called "Reimburse amount override" and then I added to the main form. And then I came up with the following formula; If([Reimburse Amount Override]>=0,[Reimburse Amount Override], If([Category Requires # of 1-Way Trips Field], If([Category - Multiplied by Mileage], ([# of 1-Way Trips] * [Category Rate]) * [Resource' Commuter Miles 1-way], ([# of 1-Way Trips] * [Category Rate]) ), [Mileage Cost]+[Cost] )) Now the override works fine, but the problem is when I put so "cost", and I leave "Reimburse Amount Override" blank , the formula won't work anymore! ------------------------------ Michael Naser ------------------------------ Working on Nested if StatementHi Everyone, I was working on a currency formula, but it looks like my nested if statement does not work properly. The formula that I have now is If([Reimburse Amount Override]>=0,[Reimburse Amount Override], If([Category Requires # of 1-Way Trips Field], If([Category - Multiplied by Mileage], ([# of 1-Way Trips] * [Category Rate]) * [Resource' Commuter Miles 1-way], ([# of 1-Way Trips] * [Category Rate]) ), [Mileage Cost]+[Cost] )) The problem here is that Override works fine, but when I put "cost" and l leave "Reimburse Amount Override" blank , it does not calculate the cost any more! ------------------------------ Michael Naser ------------------------------