Need help with a filter

[Anonymous]

Hello!

I need some help,

I got a combobox with several choices in it, "Ongoing", "Finished" etc.

I want to be able choose several statuses at the same time including "Finished" but the items with status "Finished" should only show when "Created" Today.

I got this code but it shows all statuses as ">=Today":

Filter(
   Sort(
   'Logg';
'Case received';
   Descending);
   TextInput1.Text in 'Case numer' & 'External Case number' & 'Createdby'.DisplayName;
       Area.Value in ComboBox2.SelectedItems.Value ;
       Status.Value in 'ComboBox status'.SelectedItems.Value&&
         If(Status.Value in 'ComboBox status'.SelectedItems ; "Finished";'Created'>=Today())
   ))

[RandyHayes]

@Anonymous 

Consider changing your formula to the following:

Filter(
   Sort('Logg';
       'Case received';
       Descending
   );   
   TextInput1.Text in 'Case numer' & 'External Case number' & 'Createdby'.DisplayName  &&   
   Area.Value in ComboBox2.SelectedItems.Value &&   
   Status.Value in 'ComboBox status'.SelectedItems.Value &&   
   If("Finished" in 'ComboBox status'.SelectedItems; 'Created'>=Today(); true)
   
)

This formula will filter a sorted list from Logg and include any records where the text in the inputbox is in the combination of three columns as shown and the Area value is in your ComboBox2 selections and the status value is in your Combobox for status and if "Finished" is chosen in your combobox, only the records where Created >= Today().

I hope this is helpful for you.

[Anonymous]

@RandyHayes 

This code wont work for me, I get no errors. When I filter with the comboxes all statuses is still >=Today(), it should only be the status "Finished" that shows >=Today() the rest of the statuses should be able to show past dates.

[Anonymous]

@RandyHayes Hello again!

I still havent been able to solve this, its kinda urgent. I really appriciate the help.

I will try to explain better how I want the whole scenario to look like.

All objects with the other statuses except "Finished" should be static and always be visible, but those objects that have the status "Finished" should dissapear from the gallery after >=Today(). Is that possible to achive?

[RandyHayes · Accepted solution]

@Anonymous 

Based on what you are saying then I believe this is more inline with what you might need:

Filter(
   Sort('Logg';
       'Case received';
       Descending
   );   
   TextInput1.Text in 'Case numer' & 'External Case number' & 'Createdby'.DisplayName  &&   
   Area.Value in ComboBox2.SelectedItems.Value &&   
   Status.Value in 'ComboBox status'.SelectedItems.Value &&   
   If(Status.Value="Finished"; 'Created'>=Today(); true)
   
)