Forum Discussion

Sn3l3's avatar
Sn3l3
Copper Contributor
May 10, 2023
Solved

Date to Text Calclution

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

microsoft lists
SharePoint Online
  • Sn3l3's avatar
    Sn3l3
    May 11, 2023
    Got it fixed.
    Needed to remove the, "published" from all and only leave at the end.
    Thank you however.

2 Replies

  • Sn3l3's avatar
    Sn3l3
    Copper Contributor
    May 10, 2023
    What I am trying to achieve is - If The Next Review date is within the next

    30 days from today it should say 1 month,
    Next 60 Days from today 2months,
    Next 90 Days from today 3 months
    • Sn3l3's avatar
      Sn3l3
      Copper Contributor
      May 11, 2023
      Got it fixed.
      Needed to remove the, "published" from all and only leave at the end.
      Thank you however.