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 Revie...
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.
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.