If date is changed update weeknumber

Hello I have a simple question. When someone choses a date my week number is automatically selected. the problem is that if he modifies that entry (after it has been saved ex: the next day) and changes the date, the week number is not updating it self.

this is the current formula:

WEEKNUM([date])

I suspect you might place this to initial value rather than app formula?
Move expression onto appformula.

1 Like

yes indeed it was in initial value

If you want to make this fields editable (can be changed by users) then keep it to initial value and turn on “reset on edit”. If you want to protect filed value from user to edit but expression automatically set the value , then move expression to app formula.

you have options.

2 Likes