0

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.

5
  • 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? Feb 1, 2018 at 5:58
  • Disregard...the issue has resolved itself Feb 1, 2018 at 15:47
  • So, after all, the problem is still there. Feb 2, 2018 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? Feb 2, 2018 at 14:52
  • Add "Pause for Duration" before the actions, see if it is resolved. Feb 5, 2018 at 1:35

1 Answer 1

0

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

=IF(
    AND(
        [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 and acknowledge you have read our privacy policy.

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