Error validating the formula for column

09 May

(So for example, column validation can ensure that the date in the Date Finished column can’t be earlier than the date in the Date Started column — you can’t finish a project before it’s begun!

) To use column validation on your app: You can add column validation to columns created at the app or site level.

By Ken Withee Column validation options allow you to define additional limits and constraints for your data.

For example, you may want to ensure that a value in one Date column occurs after another Date column.

In the User Message section, we will provide the error message that will be poped out if invalid data is provided.

With Excel's data validation tools, you can control how users input data into workbooks and ensure data is entered consistently and accurately.

You can control the dates, the times, even the length of the text they enter, or simply provide a list of acceptable choices to eliminate any possible mistakes.

You can download an example workbook with all of the data validation examples you'll find in this article.

You can follow along, or create your own data validation scenarios.