This should return a new weeknumber.
The formula should simply take the week number from “Weeknumber” column and substract the #weeks necessary.
This works fine.
However, I’m trying to automatically display this value from the formula column in a monday doc using the new function “Dynamic values”.
So I add Dynamic values and choose the formula column for the new week number.
However the doc returns “No value” even though the value in the actual column view shows up correctly. The problem is to make it work in the monday doc.
Anyone know if I can alter the formula in some way to make Monday doc recognize the number in the formula column and display it correctly?
Watching this post! I have the same issue of getting “No value” from my formula columns in the workdocs when using the dynamic value from columns in my board
It seems like the “No value” error occurs because the dynamic values feature might not be recognizing the formula result. Try ensuring that both “Weeknumber” and “#Weeks necessary” are formatted as numbers. If they are, try refreshing the board or reconnecting the dynamic value in the doc to see if that resolves the issue.kineprohub