How can filter by date and add the column

[LETICIAHELENA]

example> today's date the new column will shows the text "urgent"

ans for the others dates just show's "ok"

[Luke_C]

Hi @LETICIAHELENA 

Are you looking for something like this?

[LETICIAHELENA]

Yes!!!! Thanks a Million 

Luke I have one more question, if in one Column a have number 1,2,3,4,5,6,7,8 and  I want just the number 1,4,5,8 is it possible just with one filter I selects the number that I want? 

[Luke_C]

Hi @LETICIAHELENA 

You could use a filter tool with a custom formula, for example [Column1] in (1,4,5,8). If your column is a string you'd need to put each in quotes. 

[LETICIAHELENA]

@Luke_C I created the condition below but my  result is not correct.Because today is 2023/03/30 ans should show the text media and as you can see below shows the text Baixa. Could you help me ?

[Luke_C]

Hi @LETICIAHELENA 

Important to note that your field is DateTime, not Date. If you use a select tool to change Data Prevista to 'Date' type it should work fine. 

[LETICIAHELENA]

@Luke_C ok I got, is because my original excel I don't have date just " data prevista" Do you how can I transfor the colum  2023-03-31 00:00:00 just in Date 2023-03-31?

[Luke_C]

@LETICIAHELENA  Use a select tool