In Forms when you set a field to be validated as Numeric, it would be nice to be able to show a field based on the number being =, >, <, <>, ⇐, >=.
I have seen questions on this, but couldn't find a submitted idea.
Sign in to see the current vote count, add your own vote, or leave a comment.
I'm trying to create a project intake form, and we have a policy that projects over a certain dollar amount require an additional approval step. I've set up the field to accept numbers only in the form and formatted it to USD$ currency in the sheet, but the only options for conditional logic in the form are for "contains, does not contain, blank, not blank." There is no option to trigger a follow-up question if the number is greater than a defined value.
I asked this as a question in another thread, and this is not a current feature, but I can imagine others would also like to have this functionality.
@Iowa.KatelynH While you may not be able to trigger a follow up question if the entered number is above a certain threshold, your comment about an "additional approval step" may be covered by an approval automation workflow that triggers based on the number being submitted (if your approval process is managed in SS).
Although we are extremely proficient when it comes to reducing load on our smartsheets (we use pivot, data mesh and data shuttle extensively), we still find ourselves hitting capacity limits (mostly because of the number of columns in conjunction with some pretty complex formulas). Breaking up data between sheets and…
Be able to print and/or export Workflow Automations in PDF and/or export to Visio. this would be used for document control and troubleshooting aid
It would be beneficial to be able to leverage Smartsheet Automations to make REST API calls. This has many potential use cases, but one I could see is adding users to Smartsheet groups when the are added to a 'roster sheet' in Smartsheet. It would allow us to use the full power of Smartsheet's API within easy to use…