To display user sign - in in column

[Ing_Fred_Fiifi_]

PLEASE I HAVE AN APP BUT I WANT THE USER WHO SIGN -IN USER NAME TO SHOW IN THE TECHNICIAN COLUMN

PLS HELP ME

[Steve]

help.appsheet.com

App Formulas and Initial Values

How you can set app formulas and initial values to dynamically assign values.

help.appsheet.com

USEREMAIL()

User's email address

[Ing_Fred_Fiifi_]

Please Steven with respect can you show me the expression for that or the formular to show the user name in the column

[hru]

I use expression like below to populate user name in the column:

USERNAME()

With condition that I’ve set-up all my users Google+ account with a GSuite corporate account.

[Ing_Fred_Fiifi_]

thank you

[Ing_Fred_Fiifi_]

please how do i convert IF(RC[-2]>70%,“OVERLOAD”,IF(RC[-2]>50%,“ALERT ZONE”,IF(RC[-2]>40%,“AVERAGE”,IF(RC[-2]>30%,“OKAY”,“OKAY”)))) into app formula

[Jonathan_S]

Have you tried? Its a pretty complex formula for your first post.

Where did this formula come from.

Background and details? what are you trying to do, this way other people can learn as well.

[Pratyay_Rakshit]

Ing_Fred_Fiifi_Arthu:

please how do i convert IF(RC[-2]>70%,“OVERLOAD”,IF(RC[-2]>50%,“ALERT ZONE”,IF(RC[-2]>40%,“AVERAGE”,IF(RC[-2]>30%,“OKAY”,“OKAY”))))

ifs(
RC[-2] > 70, “OVERLOAD”,
and(RC[-2]>50, RC[-2]<70), “ALERT ZONE”,
and(RC[-2]>40, RC[-2]<50), “AVERAGE”,
RC[-2]<40, “OKAY”
)

It’s like a switch statement in C.
You have to put the RC[-2] column within squared brackets though, [RC[-2]], provided RC[-2] is the EXACT column name that you are trying to format with ifs.

Ing_Fred_Fiifi_Arthu:

I WANT THE USER WHO SIGN -IN USER NAME TO SHOW IN THE TECHNICIAN COLUMN

1. Keep a separate “user” sheet where there will be user (technician) name columns associated with their e-mails. Let, the name column is named as [Tech_Name] and the email column is named as [Tech_Mail].

2. Make a slice from the user sheet that filters out all but the current user. The row filter condition would be [Tech_Mail]=useremail(). Say, name that slice Profile Slice

3. In the technician name field, use any(Profile Slice[Tech_Name]).

[Ing_Fred_Fiifi_]

ifs(
RC[-2] > 70, “OVERLOAD”,
and(RC[-2]>50, RC[-2]<70), “ALERT ZONE”,
and(RC[-2]>40, RC[-2]<50), “AVERAGE”,
RC[-2]<40, “OKAY”
)

UNABLE TO FIND COLUMN [RC[-2]]

ANY HELP

[Pratyay_Rakshit]

I seriously doubt [RC[-2]] is your column name in the spreadsheet.

If M is the column name in the spreadsheet, then while using that column in the app, it should be written as [M].

I surmise it’s RC[-2] in your spreadsheet, so please use [RC[-2]] in the expression, rather than [[RC[-2]]]