Unknown field "assigned to"

Hi Yves Bourgarel ,

assigned_user_name is not a valid field to use for the purposes of Sugar Logic formulas, you could do something like the following:

ifElse(
    equal(
        concat(
            related(
                $assigned_user_link,
                "first_name"
            ),
            related(
                $assigned_user_link,
                "last_name"
            )
        ),
        "YvesBourgarel"
    ),
    "1",
    "2"
)

An alternative I do for a lot of our clients is to create a custom text field in the Users module which represents their full name with the following formula:

concat(
    related(
        $assigned_user_link,
        "first_name"
    ),
    " ",
    related(
        $assigned_user_link,
        "last_name"
    )
)

I find this custom field useful for grouping in summation & matrix reports (as opposed to grouping by user name) as well as simplifying formulas like the one for your use case. Your formula would then look like:

ifElse(
    equal(
        related(
            $assigned_user_link,
            "full_name_c"
        ),
        "Yves Bourgarel"
    ),
    "1",
    "2"
)

Chris

Oh strange... i deleted my initial question, because i found the answer a few minutes later :) 
and i indeed used this to resolve the problem :

related(
$assigned_user_link,
"first_name"

thanks tho

Oh strange... i deleted my initial question, because i found the answer a few minutes later :) 
and i indeed used this to resolve the problem :

related(
$assigned_user_link,
"first_name"

thanks tho