I am stuck getting this to work and have been trying both ISERROR and ISBLANK but keep getting an UNPARSEABLE error. Here is the overview of what I need to do:
First, I have a column [Cumulative Delay for Start Date] that increments based on other values for a row. The second column is the base starting date [CALC DATE] that comes from a date modified field. The [CALC DATE] is returned from the automation when the user selects 'Offer Letter' under the [Final Outcome] column. Only when 'Offer Letter' is selected do we compute the Start Date. I need to determine the start date for the applicant beginning with the [CALC DATE] + 42 days + the value in [Cumulative Delay for Start Date].
So long as there is a valid date in [CALC DATE], no issue with this formula:
=([CALC DATE]@row + 42 + [Cumulative Delay for Start Date]@row)
However, if the [CALC DATE] field is blank and a column formula is attempted, it calculates what appears to be 42 appended to the [Cumulative Delay for Start Date]. So the Start Date fills with values like '42120', '420', '42240', etc.
The sections in green are where the formula woks appropriately because there is a valid date in the [CALC DATE] field when 'Offer Letter' has started the trigger.
When an application is incomplete and I leave that column formula in place, then you get the items in red boxes.
I have tried to adjust the column formula to use ISBLANK like so:
=IF(ISBLANK([CALC DATE]@ROW, “”,[CALC DATE]@row + 42 + [Cumulative Delay for Start Date]@row))
I hope you can help me with this. Basically, I don't want the calculation to happen unless there is a valid date in the [CALC DATE] column for the row. What am I doing wrong?
