If and if/and statement
I'm trying to do an if statement for if a cell is blank to leave it blank and if not to perform an if/and statement. I did it in Excel but when I imported the file into Smartsheet it wasn’t working. So I’m trying to write it in Smartsheet.
I did get it to work at one point but the acceptable and review responses were backwards. Now I continue to get errors when I’m trying to fix it .
i want if my ratio is below 100% and the increase is more than 5% to return “acceptable”, if not to return “review” and if the increase amount if blank to return a blank cell.
Help Article Resources
Check out the Formula Handbook template!