if then selection error

87
1
02-20-2020 11:31 AM
JayStalnacker
New Contributor

Hello, 

I am trying to populate a field based on a select_one field type. When I save my spreadsheet I get the following error

I have attached a spreadsheet to provide the calculation I am getting the error on. Any help would be greatly appreciated. 

Thank you

0 Kudos
1 Reply
DougBrowning
MVP Frequent Contributor

Looks like you are missing the then part.

0 Kudos