May 10 2023 09:17 PM - edited May 10 2023 09:53 PM
Any help on a date to text calculation
I Have have a single Line of Text field and would like to calculate the following
=IF([Next Review]-30<TODAY(),"1 Month","Published",IF([Next Review]-60<TODAY(),"2 Month","Published",IF([Next Review]-90<TODAY(),"3 Month","Published")))
For some reason It is not displaying. Am I missing something
May 10 2023 09:47 PM
May 11 2023 05:27 PM
SolutionMay 11 2023 05:27 PM
Solution