Multiple formulas

11166 · 05-20-2020 12:11 AM

Ask the teacher
As attachment
When there are multiple formulas
Is it connected with “AND”?
Thank you

hru

For that expression, the pattern is something like:

IFS(
	ISNOTBLANK(...),
	ORDERBY(FILTER(....),[ColumnName],TRUE)
)

11166

Thank you, teacher
Can be used
Ask the teacher:

Q1.
ORDERBY (PARA1, …)
I don’t understand PARA1 yet?

Q2.
IFS (
ISNOTBL ANK (IAREAI),
FILTER (“personne!” ([AREA] = [-THISROMI [AREAD)
AND
ORDERBY (personnel1. [SEQUENCE], [INPUT SEQUENCE], TRUE)
AND
ORDERBY (personnel2. [SEQUENCE2], [INPUT SEQUENCE2], TRUE)
If there are 3 times, how should the formula be written?

Thank you

hru

Better to go through the syntax:

Steve

If you want to create one new list from the contents of three other lists, you can add the lists together using the + operator:

(
  IFS(
    ISNOTBLANK([AREA]),
      FILTER(“personnel”, ([AREA] = [_THISROW].[AREA]))
  )
  + ORDERBY(personnel1. ...)
  + ORDERBY(personnel2. ...)
)