Formula Help

Breelyn Brown

Hello,

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", "")

James Keuning

start with replacing the & with +

James Keuning

start with replacing the & with +