Hi all,
Adding on to an existing formula to automatically add a number of days depending if a column is checked or not.
The bone column is either "NA" or various types of bones which populates the final date in the QC column based what is selected. I'm trying to add if the Timeline extension box is checked, it will add the number of days listed in the Days Extended column to that QC date. Right now, the formula below works if I have Sternum selected: It will adjust the date based on the timeline column being checked or not. But when I change Bone to NA, it still displays a date for that selection but it no longer adjusts the date when checking the extension column box. Do I need another IF statement somewhere or if this requiring an AND statement to make it work regardless of what is selected in the Bone column?
Thank you in advance!!
=IF([Last Nx/End Date]@row = "", "01/01/22", IF([Histology Requested]@row = "No", [Last Nx/End Date]@row, IF(OR([Decal Start / Trim]@row = "NA", ISERROR([Decal Start / Trim]@row)), WORKDAY([Stain / Scan]@row, 1, {KAN Holidays Range 1}), IF([Timeline Extension]@row = 0, WORKDAY([Stain / Scan]@row, 1, {KAN Holidays Range 1}), WORKDAY([Stain / Scan]@row, [Days Extended]@row + 1, {KAN Holidays Range 1})))))