I have a Nintex workflow for a SharePoint 2013 list. The list has a "Due Date" date column and an "FY" calculated column. FY calculates the Fiscal Year from Due Date. When I run the workflow on an existing item, FY is present and the workflow works as designed. But when I run the workflow automatically on a new item, FY has not been set, and the code fails.
Is this typical behavior? Would it be best to pause the workflow until FY has been populated before proceeding? Since the workflow fires after the save, I'm not sure why the calculated column is not already populated.
Solved! Go to Solution.
Hi @Michel , I have a somewhat similar situation. I have a calculated column for a DueDate. It is conditional, so sometimes takes a DateEntered +2 or sometimes +4 (based on another calculated column). Bottom line, this populates the DueDate always upon the initial entry, so this field exists and would be available to the workflow yet the Workflow still does not read/show this column.
Is this still a case where you'd recalculate this on the fly inside the workflow? I would certainly prefer to use the DueDate I already have set up with the proper logic. I also found it difficult to see how I would do more than one condition for the calculation since I have two calculated columns in the source.