Automation, condition criteria
Hi all.
looking to understand exactly what a condition in a workflow is looking for. If I set a condition where the value in a cell, in our case its a sales value, "is greater than or equal to" 20000 is the trigger & condition looking for it exactly as typed or will it recognise $20,000.00?
Through form entry I want it entered by the teams as $20.000.00. I have tried formatting the column in our currency but if entered as 20.000.00 the sheet will not add the $ when form is submitted.
Cheers.
Answers
-
If the sheet isn't adding a $ when you have the column formatted as currency, that means SmartSheet doesn't believe you've entered the correct format for the number to be a currency. Maybe it's something to do with your Regional Preferences and not having your SmartSheet profile set to the correct Regional Preferences for it to recognize periods as commas etc.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 213 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives