Check that it cannot be repeated, how should it be set?

Ask the teacher
If you want to add data to the attachment, please use [AREA] + [[NAME]
To check that it cannot be repeated, how should it be set?
Thank you, teacher

What are the current Valid If expressions for the AREA and NAME columns?

1 Like

Try this as the Valid If expression for NAME:

IFS(
  ISNOTBLANK([AREA]),
  (
    ORDERBY(
      FILTER(
        "personnel",
        ([_THISROW].[AREA] = [AREA])
      ),
      [INPUT SEQUENCE],
        FALSE
    )
    - SELECT(
      Participants[NAME],
      ([_THISROW].[AREA] = [AREA])
    )
  )
)

The - SELECT(...) portion attempts to remove the names in the area that have already selected, leaving only names in the area that haven’t been selected.

2 Likes

Thank you very much teacher

1 Like


Ask the teacher
If you want to add data to the attachment, please use [DATE]+[AREA] + [[NAME]
To check that it cannot be repeated, how should it be set?
Thank you, teacher

In the Valid If for the NAME column:

ISBLANK(
  FILTER(
    "Participants",
    AND(
      ([_THISROW].[DATE] = [DATE]),
      ([_THISROW].[AREA] = [AREA]),
      ([_THISROW].[NAME] = [NAME])
    )
  )
  - LIST([_THISROW])
)
1 Like