Concatenate formula with IFBLANK


We are trying to move some of our more complex templates into Smartsheet but we're having trouble converting the concatenate with blank formulas from excel into smartsheet. For example we have this formula in excel =IF(M2="","New",M2), and all I can seem to get to in Smartsheet is =IF(ISBLANK([If nothing is indicated, value defaults to NewSTA]@row), "New Status") I need the other half to capture the cell data if it isn't blank. Any help is much appreciated!!!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!