I have this really odd issue that works in 1 document library (first image) and doesn't for another (second image).
I have 2 columns, column 1 called
Published Date (Flow) that is of type string (single line of text) and column 2 called
Valid Till that is of type calculated (date).
Based on the
Review Period (Months) column (type number), I am supposed to calculate the valid till date from the published date.
The formula I am using for the calculated column is:
= [Published Date (Flow)] + ([Review Period (Months)]*30)
Thank you in advance for any help.