MrMike ✭✭✭
edited 12/09/19 in Smartsheet Basics

Hello, I need to multiply and the divide two columns but one of them already is a formula. It's a simple sum of children which for this example is 3 and in column 1. The next number is manually entered into column 2 which is 48776. If I enter a new formula in column 3 =column2/column1 and hit enter I get invalid operation. If I manually enter the 3 without the children formula it works.