-
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…
-
Number of rows in a sight.
I have a sheet with just under 500 rows, with information about buildings. I have a report to format a concise list of information to publish, and have several widgets, including links to the maps that have some of the source data, on my sight. The Sight only displays the first 150 buildings, with a pop-up link to the…
-
Form Results Page
Can you view all form results in the same format as the form? In other words, seeing the form with answers provided (scrolling down through questions) rather than results being displayed across like a spreadsheet?
-
Form Reminder
Is there a way to set up a daily reminder via a web form without having to share a sheet with the individuals who will be completing the web form? Scenario: I have a report that needs to be ran daily by a dept. outside of my office. The report should be ran each morning for the data from the day prior. I created a web form…
