Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums. Archived 2016 Posts
Archives for November 2016
Discussion List
Copying from excel 'cell' level to smartsheet cell
I need to transfer a great deal of cell level data (including sketches that have been inserted) from an excel worksheet into my smartsheet. There doesn't seem to be a paste functionality at the cell level?? Or am I missing something really obvious?! thx!
Feature Request: Notification of lock/unlock of rows/columns to sheet owners
For the sheet owners who share sheets with admins so that they can edit locked cells, it would be good to know when the Admins are locking and unlocking the rows/columns. If they mistakenly unlock the columns, this overrides the controls put in place by the sheet owner (me). So, please create some form of notification for…
Pasting text color from Excel?
I have rows in excel where some are red and some are black.When I paste rows from excel into smartsheet, the red ones become black as well. How I can copy in those rows without losing the colors? Conditional formatting would be a work around for some of the red rows but it would not be possible for all.
webforms
I use a web form which creates a code in the actual smartsheet, is there anyway of sending that code back to the person who raised the webform?
Timeline !
Hi, Is there a way to create a timeline in the sheet without using the gantt chart?! I really need the timeline !
Link to Attachment and Making an Annotation with the Attachment
We are currently using Smartsheet in documenting our audit processes by attaching our working paper in each row. We are thinking if we can put in a cell a hyperlink to the attachment in the row. For example, in the image below: Hope you could provide us a solution for this. Thanks.
Formula in Resource % Allocation column
I have added a column to put in the number of hours I would expect the task to take each day. I prefer this to having to work in percentages of a day and think this will be easier to request of my team. To allow this I need to put a formula in Resource % Allocation column to divide the number of hours by the number of…
View Row as web form?
Hi, Can we view and update a row as a web form? We have a sheet with a number of columns and users would like to view the row in a web form style (say right click-view as web form) so that's easy to update information in cells. Its way cleaner than jumping into each cell. Thanks, Rohit
How to remain logged in on mobile device
I find it frustrating that I have to re-authenticate everytime I pull out my phone on a project to check dates. Why can't SmartSheet remain logged in just like all my other apps?? Is there something I'm missing? I've done a search but don't find any threads on this problem. Andy
countifs with specific data set and dates
I have a column with specific criteria (Sample type) and date column. I have another formula that looks specifically for a "sample type" and specific "factory". The formula I've used for this is: =COUNTIFS($Program$3:$Program$333, "Fall Tabletop / Decor", $[Sample Type]$3:$[Sample Type]$333, "DEVELOPMENT + ARTBOARD"). This…