I have a date calculate field that needs to be manually changed every now and then, maybe 1 in 10 records don't follow the pattern and need a custom date.
I used the term 'unlock' because there is a small padlock in the top right corner of the box (image attached if you don't know what I'm talking about) so I am hoping there is a way to 'unlock' the field so that I can manually change the date.
If you need anymore information let me know.
J Lupin shared this idea · Apr 20, 2018
Comments
2 comments
Hi J,
It is not possible to unlock calculated fields for manual manipulation. If you need a custom date field, add a new date field to your table that can then act as an override to the calculation.
For example, you can use the coalesce function to reference your override before running the logic that is currently being output by your calculation:
coalesce({Override Date Field}, [current calculation here])
Additional information in this function can be found in the Knowledge Base here: https://trackviasupport.zendesk.com/hc/en-us/articles/8783119784731-How-to-use-calculated-fields-and-formulas
Regards,
Alex
Hi Alex,
Not sure how to respond on here but thats for the speedy reply.
I've had a look through the link you gave and it was very useful but still struggling to get what I need.
My current formula in my Calculated Data field is something along the lines of -
If([{Type}="Kitchen", {Date Due Kitchen}, If({Type}="Bath", {Date Due Bath}, ""))
I tried using coalesce but I feel like I am using it wrong as I can't get it to work, any advice would be greatly appreciated.
Please sign in to leave a comment.