Formula error

burgandee38116
edited 12/09/19 in Smartsheet Basics

Hello! I am trying to make a formula to help track sales and I keep getting an error. I have 3 columns: Prospect Type, Outcome, and Date Sold/Upgraded. I have an if/and formula to count them for each row and if the: outcome=sold, prospect type is WCW Activation, and the date is between 2/1/18 and 2/28/18. I used the formula 

=IF(AND([Date Sold/Upgraded]1>=DATEONLY("2/1/18"),[Date Sold/Upgraded]<=DATEONLY("2/28/18"),Outcome1 = "Sold", [Prospect Type]1 = "WCW Activation"), 1, 0)

so that if it matched that criteria it'd put a 1 and if not, a 0. But I keep getting the error "unparseable". Any help would be appreciated!

Comments