Formula to match Payment Terms to a number (Nested If Formula)
Hello,
I am trying to match a number based on the value of Payment Terms. For example if Payment Terms if NET 30, NET 45, or NET 60 I want to make a formula in a separate column that match the number portion. For example Net 45 should become 45 in a separate column. My formula only seems to work if the Payment Terms is NET 30 and it says #incorrect argument set for other values.
Formula and Screenshot below.
=IF([Payment Terms]@row = "NET 30", 30, IF([Payment Terms]@row, ="NET 45", 45, IF([Payment Terms]@row = "NET 60", 60, "Other")))
Thanks for any help,
Marcel
Tags:
Best Answer

I figured out my own error now. Had an extra comma after the second @row.
Answers

I figured out my own error now. Had an extra comma after the second @row.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!