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.