Help fix error with if and formula


I am trying a formula and keep getting an error. Here is what I am trying =IF(and([Billing Status as of 04/10/2023]="Active",[Line Installation Date]@row="N/A"), "Unknown", IF(and([Billing Status as of 04/10/2023]="Inactive",[Line Installation Date]@row="N/A"), "N/A",IF([Installation Year]@row > 1988, "Yes", IF([Installation Year]@row < 1988, "No", "")))


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!