Formula Help


I am not the greatest at formulas and these two I can not figure out what I am doing wrong. Can someone help me? They work in excel but not smartsheet.

=IF(AND([BO PC@row] >= 1),IF(LEFT([Store Number@row],3) = "274",REPLACE([Store Number@row],1,2,"STR"),IF(LEFT([Store Number@row],3) = "265", [Store Number@row]&"BO1")),"")

=IF([Holiday Router Info (1 each )]@row = 1, [Store Number]@row]&"RO1", "")

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!