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. Discussion List
Hi there
my problem is that the smartsheet has around 3000 lines ... so it's nearly immpossible to work with this sheet. That's not the main problem because our users just work with sights an reports to this sheet - no problem with speed. Most of the lines are finished. But we have to store them for further activities. So it would…
Can you import a list of values into a drop down list?
For example, I have a building with over a hundred rooms, I want to load all the rooms into the drop down for a 'Room' column field so it can be choosen from the list using a mobile device.
Time correction in Date Submitted
Greetings, I have a Date Submitted column for a web form. The time displayed in the submission is fast by 3 hours. Any ideas how to change it from Eastern time to Pacific?
Card View IF Statements
I am trying to figure out if you can add an IF statement that says if you move a card to complete that it will mark the % complete in the project to 100%. Is this something that is possible? Thanks, Dan
RYG Ball IF Statements
I have been trying for a few a while now to get the IF statement to work for automating the RYG to work off of end date and % complete. I would like to have it work where if the it is 3 days from complete and below 50% complete have it as red. If it is 51% to 90% yellow and 90% to 100% green. If on the last day it is still…
Feature Request: Mimic specific sheet(s) in Report
This can be done manually, but is time consuming: I would like a Report that mimics a specific sheet*. That is, the Report would display all columns in the same order as displayed in the sheet. Currently, this is a manual process which is OK for a sheet with a dozen (or even two) columns, but I'm working with sheets that…
Align Gantt chart with Timeline above?
Hi All: I'm a new user...Ihope this question is not too silly? The horizontal timeline above my Gantt chart is several days off. How do I get it to properly align with the Gantt bars below? My start & finish date columns are correct and the calender view shows the correct dates. Thanks in advance.
No webform submitted alert
Hi, I have a sheet setup for data to come in daily through a webform. What I would like to know is if there is a way for me to receive an alert if the webform has not been submitted for that day?
Formula to check percentage total
Hi I have a sheet which is pulling through some data from other sheets via cell links. The cells are being pulled from a Project Plan (with rolled up section totals). Based on this data, I want to set some conditional formatting on my sheet. I have: %COMP STARTDD ENDDD 55% 10/08/16 22/08/16 I'm using a formula (hidden…
Can you add extra columns with the Kanban view?
Can you add extra columns with the Kanban view? I would like to add this week, and today columns