Skip to main content

'unlock' a calculated field?

Comments

2 comments

  • Tiffanie Staver
    Alex commented  ·  April 20, 2018 7:36 AM

    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

    0
  • Tiffanie Staver
    J Lupin commented  ·  April 23, 2018 3:25 AM

    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.

    0

Please sign in to leave a comment.

Powered by Zendesk