A program to recognize and reward our most engaged community members
@Jon Pernice Nice to meet you Jon. Yes it is possible. In the drop down menu, you can create a calculated field using If statements with And, Or, and other conditions.If you have the most current version it should be in the drop down menu under Column>New Formula Column.The statement in Monarch is written a little differently than in other software. It would look like this;IF([Price]> 0 .and. [Item]='CD', 1, 0)I will try and send some screenshots later or a video if that will help. ------------------------------Baba MajekodunmiSolutions ConsultantAltair Engineering Inc.Manassas VA978-275-9325-------------------------------------------------------------------------Original Message:Sent: 06-04-2020 04:05 PMFrom: Jon PerniceSubject: IFsHelloIs it possible to do IFs statement in prep studio with and.Thanks------------------------------Jon Pernice------------------------------"