-
Attachment form does not give option to upload file from the computer
When i am trying to upload an file in workspace or smartsheet, the attachment form pops up but it doesnt have option to upload from my computer. What can be the reason, any suggestions from anyone?
-
Sync Error
I am getting the following error trying to sync a Google Form to a Smartsheet: Error: Start Send (create sheet): Exception: Request failed for https://api.smartsheet.com/1.1/token returned code 400. Truncated server response: {"errorCode":1071,"message":"Invalid Grant. The authorization code or refresh token provided was…
-
Creating Web forms with Auto-populated form content
I see that you can auto populate a section of the form by manually entering (post-URL): &ColumnName=text where any spaces in the text are replaces with %20. Question: I first used the substitute function to replace %20 for all spaces in a column that contains the desired text. But am unable to have the sheet pull that…
-
Having problems with sums
Hello. I am trying to add some totals in a column. It's a pretty simple thing that I do in Excel all the time. I am just clicking on a few cells in a column to be part of a total. However, after a do about 3-4 cells, it stops working and the cell with the total says #UNEXPECTED OPERATOR. Any idea what I'm doing wrong?…
-
Any way to add some info OUTSIDE the cells or expand ONE cell only?
Is there a way to add info to the sheet that would show outside the cells? i.e. carve out a space in the upper left part of the sheet to identify some items without them being in a row or column? Or if the upper left cell could be expanded AND formatted to add infor I'd want to see each time I open the sheet, but is not…
-
Conditional Formatting editing
Hello, Is there a way to delete a condition(s) from a rule without deleting the entire rule? Or do you have to delete the entire rule and start over with a new rule?
-
Conditional Formatting organization
Hello, Currently the only way to organize all of your conditional formatting rules in a sheet is to "Move to Top" or "Move to Bottom" one by one. If we have tons of rules in a sheet, this can be extremely time consuming. Is there a way to quickly organize rules by priority? Please advise.
-
Conditional formatting for past dates dependent on other past dates
Hello, Is there a way to condtionally format dates in the past based on other dates in the past? For example, we are transitioning our project schedule from excel to smartsheet. We have dates in the past as shown below. In excel they are conditionally formatted to turn red if the Actual happened after the Current Target.…
-
Printing Columns
This could be a 'newbie' problem, but we'll see: When I export a Gantt chart to a PDF, the start, finish, and duration columns do not appear, even though they are clearly visible when I look at the sheet on the screen. I can look at the lines on the chart itself, but sometimes it's easier just to look at the text in the…
-
'Enter' submits Smartsheet form
Hi all, Is there a way to change the settings for a form so hitting 'Enter' doesn't automatically submit the form? I have respondents who are inadvertently submitting a partial survey. Thanks in advance, Renae