Follow-on question to IF Statement <= Date Calculated Column:

Adding the Date function fixed the problem. However, it does not work on other days, unless I modify (OK) the Calculated Column, everyday. This is a short term fix, how do we get a long term fix?

It also reverted to "CCEA-18-147", instead of "...-295" after I modified the name of the item.

  • Based on your post, your requirement is “Check if Date Created is earlier than 31 December 2017, than input CCEA-17-(ID+147), otherwise input CCEA-18-(ID+147)”. Why do you need to modify the calculated column Every Day? What is the data you need to modify? What do you want to achieve? Could you provide some samples? – JoannaW_MSFT Feb 1 '18 at 5:58
  • Disregard...the issue has resolved itself – Dave McEwan Feb 1 '18 at 15:47
  • So, after all, the problem is still there. – Dave McEwan Feb 2 '18 at 14:31
  • So, after all, the problem is still there. The item Tracking # comes in as ...-147 on the List and in the workflow e-mails "Please do not reply. This is an automated email. VIEW IN HTML 480 ISRW/CCEA is processing Tracking #CCEA-18-147." The Tracking # is offset by 147 due to previous entries. If I modify (click OK) to the Tracking # column, the entry updates in the List. How do I have the Tracking # updating automatically? – Dave McEwan Feb 2 '18 at 14:52
  • Add "Pause for Duration" before the actions, see if it is resolved. – JoannaW_MSFT Feb 5 '18 at 1:35

I have read your previous post, and to achieve what you want, you can use multiple conditions in you SharePoint calculated column.

        [DATE CREATED] <= Date(2017,12,31),
        [DATE CREATED] <> Date(2017,12,31)
    ("CCEA-17-"&[Submission ID#]+147), ("CCEA-18-"&[Submission ID#]+147")

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.