topic Re: Formula for Action in Sheet in App Development

Formula for Action in Sheet

l26b — Wed, 09 Apr 2025 07:37:42 GMT

hi, I have an action on a sheet to select value in a filed with filed being Week number.

I want it to select Max Week and Max week - 1 from the Maxium Year

=Num(Max({< [Year] = {'2025'} >} [Week])) - but this formula is not working properly

I want it to select last week and current week but I have multiple years in the app and I want it to always select max week from max year

I have a Fiscal week and can't select week(today)

thank you

VBD — Wed, 09 Apr 2025 08:24:55 GMT

Hi,

How is create your field "week" ?

Regards,

Chanty4u — Wed, 09 Apr 2025 11:55:00 GMT

Week = Max(TOTAL {<Year={"=Max(Year)"}>} Week)-1)

BrandonFontes — Thu, 10 Apr 2025 16:19:29 GMT

Crie uma flag no script informando quando for a semana atual ou a semana atual -1.