-
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…
-
Formatting Date in Smartsheet with Month Name Displayed
When using the column type of "DATE" the only way dates are always displayed as numeric values. However, some of my colleagues are requesting that the dates be displayed as Feb 12, 2016 or 12 Feb 2016, etc. Is this possible in Smartsheet? The only preferences I have located are the user preferences where you localize your…
-
Signature in Smartsheet
Is it possible to add a signature in my Personal Settings that I will have automatic signature in all my mails from smartsheet, even when I'n sending rows to somebody. Kind Regards, Ivan