What are you trying exactly to do with your formula?
Can you share your current code?
How to use Today() function in a formula-based custom field?
I am getting an error - not in context
Please sign in to leave a comment.
What are you trying exactly to do with your formula?
Can you share your current code?
Hi Roei,
Did you manage to resolve this?
I've got a similar use case.
Hello,
I see 2 workarounds for this:
- If your formula doesn't use any other fields (just "hardcoded" values), you can create a new Scheduled Workflow rule that will run every day (at 1 A.M. for example) to update the value the way you want. Maybe you could lock the value if you set the custom field to be editable through API or workflow only
- If your formula uses other fields, create a new custom field C_TODAY at the workitem level (or maybe the organisation level, if you can access this field with your formula), and use the Scheduled Workflow rule to set that value every day. Then, just use that field in your formula based custom field.
Hope that helps,