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
Search
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
Search
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.