Time stamp on a task status | Community
Skip to main content
B
BrittanyB8
Level 3
August 7, 2020
Question

Time stamp on a task status

  • August 7, 2020
  • 2 replies
  • 509 views

I had this on a calculated field on a custom form. It's set to a specific status name.

IF(ISBLANK({INPD Status In Progress - Time Stamp})="TRUE"&Status="INP",$$NOW,INPD Status In Progress - Time Stamp}).

It got accidentally taken off the form and when I put it back on the form, it took it out of the calculation section. Luckily, I had it in the description but when I went to add it back into the calculation section, it gives me the invalid error. Any ideas on how to get it back for reporting?

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    2 replies

    skyehansen
    Community Advisor and Adobe Champion
    skyehansenCommunity Advisor and Adobe Champion
    August 7, 2020

    At a guess, I would probably say add the blank field first, then save it, then go back into the form and add the calculation. When calculations reference themselves, you sometimes get an invalid error because the calculation doesn't exist on the form (so basically just adding it to the form doesn't mean it exists--you have to save it in order for it to exist... hopefully that made sense)

    Doug_Den_Hoed_AtAppStore
    Community Advisor
    Doug_Den_Hoed_AtAppStoreCommunity Advisor
    Community Advisor
    August 8, 2020

    Ehm...another thing, @Brittany Buckwalter‚...

    Once you do reinstate that formula, your old data will us $$NOW (vs “back then”) so your calcs will be off. If you value the original data, I suggest you grab it from your [domain].preview.workfront.com today (eg if it still exists, before it doesn’t tonight after the preview refresh) and save every row you care about to excel (with it’s ID in column A and the original INPD Status In Progress - Timestamp in column B). Let me know if you do get it in time, and if so, I can help you then reinstate it.

    Regards,

    Doug

      Terms & ConditionsAccessibility statement

      Loading footer...