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:
I suspect you might place this to initial value rather than app formula?
Move expression onto appformula.
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.