IF/Case Statement Issue
I have the following fields 1. SO TYPE (Multiple Choice) 2. DATE FIELDS (Date) 3. INITIATION DAYS (Formula Duration) 4. INITIATION DAYS RANGES (Formula Duration) My Initiation Days formula ...
Forum Discussion
try this
IF(
[Initiation Days]<days(19),"0-18",
[Initiation Days]<days(38),"19-37",
[Initiation Days]<days(57),"38-56",
"More Than 56 Days")
IF(
[Initiation Days]<days(19),"0-18",
[Initiation Days]<days(38),"19-37",
[Initiation Days]<days(57),"38-56",
"More Than 56 Days")
- I changed the field type to formula text & the formula you provided worked perfect! Thank you for your quick response.
