Hey Community - I'm trying to bucket my projects based on the Penetration Days which is a duration field - this will help me establish how long the projects have been in the system. I keep getting an error "Expecting Bool, Text"- Please advise - Thank you
If([Penetration Days]<Days(0),"Not Aged",
[Penetration Days]>Days(1),"0-3 M",
[Penetration Days]>Days(91),"4-6 M",
[Penetration Days]>Days(181),"7-9 M",
[Penetration Days]>Days(271),"10-12 M",
[Penetration Days]>Days(366),"13-18 M",
[Penetration Days]>Days(547),"19+ M",
)
------------------------------
Jack Woods | Low Code 4 Lyfe
------------------------------