-
New Template(s) for The Public
I want to get this template to smartsheet for the community. Its for a family event with multiple data such as room availability, price, tax deduction, package and room assignment with form. Don't know how to donate this, but I would love to as its great for family get togethers. Won't do another one for 4 years cuzz it…
-
Trying to have autonumber show in a webform.
Hi all, I am creating a survey in SS, with a form for collecting answers. I'd like to use a auto number column as a way to create a unique ID for each row. However, I'd like that unique autonumber to show up in the form. This is so users when filling out the form, can see the unique ID associated with their submission. Any…
-
Submitting Product Enhancement Requests
I understand that by submitting a "Product Enhancement Request" it doesn't mean it will be actioned and even if it is, will materialize in the immediate future. I think that rather than it them seemingly disappear down a 'black hole' a published list and the status of requests would be useful.
-
If(And( Greater Than Less Than)
I am having trouble with the following formula: =IF(AND(Percent1 > 0, Percent1 < 6), "Scope", IF(AND(Percent1 > 5, Percent1 < 11), "AE Selection", IF(AND(Percent1 > 10, Percent1 < 21), "Design", IF(AND(Percent1 > 20, Percent1 < 26), "Bid", IF(AND(Percent1 > 25, Percent1 < 96), "Construction", IF(AND(Percent1 > 95, Percent1…
-
Sending Update Request
Hi, Is there a way to select more than 1 row when sending update requests? For example, I have a teacher that tutors 3 classrooms. When I filter for those students, I get 100 rows. Is there a faster way to select all of the rows for updating or do I have to select one at a time? Thank you. PM at a Virtual Charter School
-
Smartsheet-JIRA sync via formulas?
Hi guys. I'm using the Smartsheet-JIRA connector. I have a workflow where the Status of each JIRA ticket flows back into Smartsheet. Then formulas in Smartsheet change the Priority of a row once its predecessor is complete. The idea is that you have a bunch of tickets in JIRA that are marked as priority Blocked if they…
-
Please move "Refresh" to the toolbar, and give me a keyboard shortcut.
I would really like to see "Refresh" added to the toolbar. I think a lot of other people would too. Synchronizing changes with other collaborators in near-real-time relies on hitting refresh repeatedly. It's hidden behind a drop-down. Getting new users to refresh (or save) consistently as a matter of best practice has it's…
-
Static Date/Time Time Stamp formula
I am looking for a way to create a static date/time when a specific action is completed in a cell. Currently we created the formula below, but we need it to return a specific static date not just todays date, which changes every day. =IF(AND([Manager Approval]3 = 1, [Internal Processing Status]3 = "SERVICE COMPLETE"),…
-
Form Field to Comments
Is there a way to have a field on my form that would input the text to the comments for that row?
-
Automatic Address Finder
Does anyone know if smartsheet has a feature whereby the address can be located automatically by filling in the postcode on a UK Address similar to https://www.parcelforce.com/postcode-finder It would be great if someone knows an app that can be integrated into the platform/worksheet to allow for me to select the correct…
