-
Rows Disappearing after having been moved from the origination page.
We have our sheet set up to where 1 sheet is used for order origination; the row is then moved to the sheet of the person who will be completing the task. The person will see it on their sheet and is able to change the status to accepted; however, in time, the row disappears all together. This is causing a lot of issues…
-
User Interface
I guess many of you are using Smartsheets to great effect in many different ways. Some of the ways I am configuring it for my clients is to act as a service request/ticketing tool (for cleaning/maintenance tasks). Customers fill in service request forms, which creates a new row in a sheet. There, a manager adds a bunch…
-
Webforms: Auto hide based on answer of other field; Alerts based on answer of field
HI, I have a few questions. Scenario: A team fills out a webform every time that a they take a call. There are different fields available to them to fill in. Some of these fields(especially towards the bottom) do not apply if one of the first fields they fill out are filled out with a specific answer. each of these fields…
-
Push Merging - Is there a way to push a record form smartsheet to a Merge function
Hi All , Calling all Merge Experts - Google docs or another applicaiton. I am looking to build a quicker more accurate solution. I have a GDoc template created, I have a list of data that I merge from. Presently I have to go to the GDocs Document to then select 'add ons > smartsheet merge" to then Select the record I wish…
-
SmartSheet Reports have limitations that make them useless for business
We recently learned the hard way that there is a limit to how many sheets a report can access! We use the report feature to create individual task lists throughout our company. Each task list searches all sheets for names in an Assigned To column and refines the search looking for a value of "Needs Action" in the Status…
-
160 character limit in field (used for sms)
Is is possible to set a l60 character limit to a field? The reason for this is that we collect texts from users (mostly by web form) that we will use for sms, but usually they write more than 160 characters which leads to extra work.
-
Unicode Text Symbols are extremely useful
Please send me an email if you would like to be added to the workspace. kriswalsh@gmail.com I love Smartsheet's native symbols and use them all the time. That being said, there are times when I wish I had more options or flexibility with them. I am sharing the following with the hope that: 1. Someone finds it useful. 2.…
-
Can If-Then formula populate Primary column?
I need to populate the information in the primary column from a dropdown menu but cannot because of the type of column. If I place a column next to it with the dropdown information, can I use an If-Then formula such as =IF(ISTEXT([Client name drop down list]1), "Text", "Not Text") where I change the "Text" to equal…
-
Is there a cap on the number of rows per sheet
Hi, i have a project that well reqire a lot of rows about 50,000. I was wounding if there is a cap on the number of rows we can have on a single sheet? Thank you.
-
Use web form to return row or report from another sheet?
I have a sheet with 2500+ rows of data + attachments. I would like to allow a technical group the ability to complete the web form with some criteria and return the rows that have the specific value in it. Ideally this would be a nice report nicluding any attachments. Can this be done? The other option is to give access to…
