Formulas

dfortuna

Good Afternoon...

We are building a sheet to include a column must have 1 of 4 different criteria can be met as well as a True/False criteria formula. When completing the form, the fields are not populating correctly and if you copy the formula down the column, it puts False in each field. What is the best way to get around the field not populating information in the column (or sheet) if you copy the formula?

Thank you!

Amit Malhotra

Hello. Right click the formula cell and "Convert it to Column Formula" rather than copying the formula down.