Weekday - ShowIf acting funny

[Mike_T]

IN(WEEKDAY([_THISROW].[Start Date]),LIST(2,3,4,5,6))

I’ve got the above expression in a Column’s ShowIf formula. The form is acting all weird. Initially when I first view the form it will appear. As soon as I select tap a button in the column it dissappears (it’s an Enum type).

Also, I have another column that should ShowIf, if the Start Date selected is a WeekEnd. I’m expecting one of the two columns to Show based on which day of the week the selected Start Date is.

Suggestions on another way to do this so the columns Show immediately and the form reacts quickly?

[Suvrutt_Gurjar · Accepted solution]

Please try
IN(WEEKDAY([Start Date]),LIST(2,3,4,5,6))

[Mike_T]

Suvrutt_Gurjar:

IN(WEEKDAY([Start Date]),LIST(2,3,4,5,6))

Thank you! Works much better now!

[Suvrutt_Gurjar]

Hi @Mike_T,

Good to know it works.

Since the question was about the usage of or rather the elimination of [_THISROW], I believe the below two explanations by senior community colleagues are very useful, just in case you have not yet come across

About [_thisrow] Questions

hello, i need some explainations about this formula : concatenate("A: ", [_thisrow], " B : ", [_thisrow].[statut] , " C : ", [key] , "D : ", [statut] , " E : ", [key].[statut]) Result : A: apBFg1Mt B : C : apBFg1Mt D : Pending E : I don’t understand why there is nothing in B and E EDIT : i change my formula, [etat] was a mistake, it’s [statut]

When to use [_thisrow] Tips & Tricks 💡

[AppSheet Explained | [_ThisRow]] A very common question, here’s a short video in an attempt to answer this question. (I’m not satisfied with this video, I will do another at some point) Short Answer: When you need to pull data from the table where the formula lives When you’re building a SELECT() formula: [Shared with CloudApp]