Is it possible to restrict amount greater than 0 and accept only 2 decimals and how?

Would like to know is it possible to restrict amount greater than 0 and accept only 2 decimals in number column.
Answers
-
Hi @Happy
There are a couple of things you could do here, depending on how strict you need to be.
One formatting suggestion would be to have a formula in a flag column that will automatically flag any row that has over 0.99 in that cell.
=IF([Number Column]@row >= 1, 1, 0)
Then you can set up Conditional Formatting to highlight that row or cell if the flag is raised. You can also set the Formatting Options of that column to only show 2 decimals (although there may be more in the background).
If that doesn't work for you and you need to lock the column to your requirements, what I would do in this instance is set the column to be a Dropdown type of column and add your 99 options as values for that column.
Then you can restrict the column to those dropdown options:
See Maintain consistency in data collection with dropdown columns
Cheers,
Genevieve
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives