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 May 2016
Discussion List
SIGHTS - Error: "Source report missing" in Report widget?
In a Sight there is a section where a project plan is shown via report widget. Source is a report based on a project plan. It worked well until today... All of a sudden the plan in the Sight is gone, although the source report is still available and showing content correctly. Since I had no idea for the cause, I tried to…
Web form notification
I have set up a sheet with a corresonding web form so people can order items that I will need to purchase for the company. What do I do so I am notified immediately that a Web form has been submitted and the request has been added to my Sheet?
Lock source links
I've created a web form that feeds a very simple tracking sheet. Each week, the person providing the info will submit their data via web form and the information flows to row one of the tracking document. In a separate sheet, I've created a dashboard that should, in theory, pull the latest data and compare it against…
Repeating the same task across multiple months
Hi I am building task lists for our global team for the rest of 2016 that I will be showing in a calendar view for them and setting up alerts and reminders on what has to be completed, when. I have a number of tasks that need to be perfomed every month; how do I set these up to repeat? The only way I can think of how to do…
Formula that updates a cell in another column
Does anyone knowif there is a way to have a formula in one cell update a cell in another column? Currently I have a formula for a check box column (Task Complete Column) that checks the % Complete and if the task is 100% complete the check box is checked automatically. eg: (=if ([% Complete]4,1,1,0) This updates the check…
Mobile Web Form
I'm new to Smart Sheet and it seems that it could work well for our company. One of the first Qs I have is how to 'use' a web form. I have created one but I don't see how to make the form apear on my iphone. The 'sheet' is visible but not the web form. What am I missing? Thanks.
Is it possible to freeze and unfreeze rows like you can with columns?
Is it possible to freeze and unfreeze rows like you can with columns?
Critical Path Task w/o Critical Path Predecessor - Is this even possible?
I was reviewing the critical path of a project last week and saw something odd. Perhaps I'm mistaken, but I believe I saw a critical path task that had no critical-path predecessors. Is that even possible? The image below shows how I have a task in red color within the gantt, but no red lines leading to it. (I checked -…
View Multiple Sheets
Is there a way to view two sheets simultaneously like you can in excel when in View/New Window?
Need a drop down list to populate it's selection based on the selection from another drop down in th
I am creating a survey sheet and forms. I have created two drop down lists in my sheet (easy enough). One holds 5 selections for neighborhoods in NYC. The second column conains addresses all over the city, all found in one of the 5 neighborhoods. I would like to be able to select a neighborhood from column 1 and then have…
