Calculated formula not working
Trying to create a calculated column,"Phase", based on number of days client has been in our program. We give clients a "Start Date" the first 30 days they are Phase1, 30 to 365days Phase2, over 365...
Forum Discussion
This puts everyone in Phase3
=IF([Start Date]+30 <=30, "Phase1", IF(AND([Start Date]+31 >30, [Start Date]+364 <=364), "Phase2", IF([Start Date]+365 >365, "Phase3", "")))
=IF([Start Date]+30 <=30, "Phase1", IF(AND([Start Date]+31 >30, [Start Date]+364 <=364), "Phase2", IF([Start Date]+365 >365, "Phase3", "")))
- This puts Everyone in Phase1
=IF([Start Date]<=TODAY()+30, "Phase1", IF(AND([Start Date]>TODAY()+30, [Start Date]<=TODAY()+365), "Phase2", IF([Start Date]>TODAY()+365, "Phase3", "")))