Good morning I ask you for help ...
I have this query in an action of a bot, the test is ok but
on the table it always writes TODAY()-1 always enters the first condition.
Because?
IF(
ISBLANK(
ANY(
SELECT(
APPUNTAMENTI AUTO[DATAAPPUNTAMENTO] ,
[IDCANE] = [_THISROW].[IDCANE]
)
)
), TODAY() - 1,
ANY(
SELECT(
APPUNTAMENTI AUTO[DATAAPPUNTAMENTO] ,
[IDCANE] = [_THISROW].[IDCANE]
)
) - 1
)
thank you
Could be many things. Start off by sending a screenshot of the column types you have set in the APPUNTAMENTI AUTO table
I understand and thank you.
add bot
i also tried with LOOKUP
IF(
ISBLANK(
LOOKUP(
[_THISROW].[IDCANE],
"APPUNTAMENTI AUTO",
"IDCANE",
"DATAAPPUNTAMENTO"
)
),
TODAY() - 1,
LOOKUP(
[_THISROW].[IDCANE],
"APPUNTAMENTI AUTO",
"IDCANE",
"DATAAPPUNTAMENTO"
) - 1
)
this is the test and it is ok but when he writes on the google sheet it always enters the first condition
User | Count |
---|---|
41 | |
25 | |
25 | |
17 | |
12 |