0

Warning message for expiring TO DO

I would like to have a warning message when the "TO DO" are about to expire and when they are expired. So I tried to build this formula:

if days(Data, today()) > 0 and 'Stato TO DO' != 4 then
styled("SCADUTO", "red", "warn");
if days(Data, today()) < 0 and > 1 and 'Stato TO DO' != 4 then
styled("IN SCADENZA", "yellow")
end
end

Basically I would like a warning message to appear to me 1 day before the deadline and another message to appear to me the day after the deadline. Where am I wrong?

 

TRANSLATE with x English Arabic Hebrew Polish Bulgarian Hindi Portuguese Catalan Hmong Daw Romanian Chinese Simplified Hungarian Russian Chinese Traditional Indonesian Slovak Czech Italian Slovenian Danish Japanese Spanish Dutch Klingon Swedish English Korean Thai Estonian Latvian Turkish Finnish Lithuanian Ukrainian French Malay Urdu German Maltese Vietnamese Greek Norwegian Welsh Haitian Creole Persian     TRANSLATE with COPY THE URL BELOW Back EMBED THE SNIPPET BELOW IN YOUR SITE Enable collaborative features and customize widget: Bing Webmaster Portal Back

Reply

null

Content aside

  • 2 yrs agoLast active
  • 84Views