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 extremely beneficial to have the ability to manually assign colors to individual projects within the Timeline View. Currently, project colors are automatically determined by the Dashboard Theme, which limits flexibility and makes it challenging to visually differentiate projects in a meaningful way. Allowing…