Solved: Send email if the data of a column is different fr... - Page 2

personal_zona · 05-11-2022 11:53 PM

[_THISROW].[Datains] <> [_THISROW-1].[Datains]

I would like to be able to send an email when after a change or addition, the value of a column is different from the one placed in the previous row. i tried with this code but it gives me error

personal_zona

LOOKUP(
MAX(
SELECT(
circuito[_ROWNUMBER],
([_ROWNUMBER] < [_THISROW].[_ROWNUMBER])
)
),
"circuito",
"_ROWNUMBER",
"Datains"
)<>TODAY()

Ho inserito questo tuo suggerimento postato da voi tempo fa e modificato, ed inserito nella condizione del BOTS e sembra funzionare bene, in pratica guarda la riga della cella [Datains] precedente a quella della modifica, e se la data è la stessa, non invia alcuna email.

View solution in original post

Send email if the data of a column is different from that in the top row