Function question

Options
HZAR
HZAR ✭✭✭
edited 12/05/23 in Formulas and Functions

Current formula used:=IF([Name A]@row = [Name B]@row, "NO", IF([Name B]@row <> [Name A]@row, "YES"))

What if I need to included the Name is blank and Column Approval required will be return as No coz currently when i used the formula above it return error since it only compare Name A=Name B it will return as No and NAme A<> Name B it will return Yes

Condition required In column Approval required

Name A=Name B No

Name A<> Name B Yes

Name A is blank No

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!