Help with if Statement

[#1]

Good Day

Can anyone please help with setting a "default" clear selection for an if statement. I have a variable called vWeek which is assigned the following value

=if(Week = '' ,Week(Today()),Week)

"Week" is a listbox populated with the weeks of the year currently running from week 31 - 46.

I would like to display the selected week value in a textbox. The above formula shows the week value e.g. 43, in the textbox when week 43 was selected in the listbox, but how do I show the current week in the textbox if no week was selected in the listbox. I basically want to do the following

If nothing selected in the week listbox

=if(Week = "Nothing Selected", Show current week, else show week selected)

=if(Week = "Nothing Selected", Week(Today()), Week)

Thank You

[swuehl]

=if(GetSelectedCount( Week ) = 1, Week, Week(today()) )

[kaushiknsolanki · Accepted solution]

Hi,

     Try this.

     =if(GetfieldSelections(Week) = 0,Week(Today()),Maxstring(Week));

Regards,

Kaushik Solanki

[#4]

Thank you

Works brilliantly. Exactly what I was looking for.

Regards

Cobus

[#5]

Hi This will work

ListWeek=1,2,3,4,5,6

=if(GetfieldSelections(ListWeek) = 0,Week(Today()),Maxstring(ListWeek))