Share
Explore

If name & date match -> change value





Compare
to
:

IF
a
name
in
is also in
AND
the
date
from that
name
in
is also part of the
date list
from that
name
in

THEN:
Change the
Value
in
to the
Value
from that
name
in

So in the example below, the
value
of row 5 and row 7 from
(=
@Value A
) should change to
@Value B

(because they are both
@Name 1
and dates "7/3/2021" & "7/4/2021" are part of
Date list
in row 1 in
)


Table A
0
Row
Date
Name
Value
1
1
7/1/2021
Name 1
Value A
2
2
7/1/2021
Name 2
Value A
3
3
7/2/2021
Name 1
Value A
4
4
7/2/2021
Name 2
Value A
5
5
7/3/2021
Name 1
Value A
6
6
7/3/2021
Name 2
Value A
7
7
7/4/2021
Name 1
Value A
8
8
7/4/2021
Name 2
Value A
There are no rows in this table
Change value

👆 this is the control where the magic should happen (for now a placeholder)

Table B
0
Row
Name
Start Date
End Date
Date list
Value
1
1
Name 1
7/3/2021
7/6/2021
7/3/20217/4/20217/5/20217/6/2021
Value B
There are no rows in this table

FYI: column
Date list
= a list of all dates between
Start Date
and
End Date














Name select list
0
Name
1
Name 1
2
Name 2
3
Name 3
There are no rows in this table

Value select list
0
Value
1
Value A
2
Value B
3
Value C
There are no rows in this table

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.