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 September 2016
Discussion List
Cell linking - finding the next empty row on another sheet
Hi, Looking for a way to link a cell in each new sheet to the 1st column of the next open row in a summary sheet. I have a template sheet and summary sheet. I would like to create a number of sheets from the template and then display some info from the sheet in one row on the summary sheet. It looks like this is commonly…
anchored tasks
How do I implement tasks that are dependent upon other tasks but who start/end to the dates I specify and not recalculated with other task parameters are changed???
View only for majority of smartsheet and give edit rights on a few columns of data
I am trying to set up a smartsheet that different groups have update requirements on different columns. Thoughts on how to accomplish. I tried creating the main smartsheet providing those other "editors by column" to viewers, then created a report for a subset of the viewers with editor rights, but the report took the main…
Blank rows showing in printed view
Hi all, I am trying to print out my project plan on an A3 sheet showing my Gantt chart and the tasks. However, when I go to print, I see two blank rows at the bottom of my sheet showing which are not needed and I would ideally prefer for these not to be shown. How could I change my sheet to not show these two blank rows?…
Automatic Parenting/Heirachy
I would like to add a request for an automatic parenting/heirachy feature based on a value or formula i.e. + Won --- Opportunities with the status colum marked Ordered +Lost --- Opportunities with Lost in the status field +Pipeline --- Opportunities without Lost or ordered in th status field This could be extended to…
Re-using Update Request Links
Is there a way to re-use an Update Request link? For example, if I opened an update request and I am not ready to post a response, is there a way to open the Update Request again? The Update Request link is a one-time only link right? Is there a way to work around that? Thank you
Stop expanding rows when un-Filtering a column?
When i filter the column to show only tasks i am assigned to and then unfilter it expands all my rows? Is there any way of stopping this. It is then time consuming to minimalise all our inactive rows. thanks Twaanie
Web Forms - Show Latest Entries
Hi There - I am using a web forms to add timesheet entries to a smartsheet. Is there any way on the web form to show say the latest 5 entries? Just in case the data entry person loses track of where they were up to it would be good if they could see at a glance the latest entries without having to go into the actual sheet.
Allow sending an individual row from iOS Smartsheet app
The iOS app version of Smartsheet currently allows sending the entire sheet via email. I would like to see the ability to select an individual row and to send that row to recipient(s) much the same as is allowed from the desktop version.
API to apply conditional formatting
I am not able to find how to apply condiional formatting via API. I have various sheets that I want to update all at once and apply different conditional formatting without having to do it via the interface manually.