-
Send Row - Filter Save
I utilize the Send Row feature on a daily basis. The majority of the time, the columns I select from the "Customize" section are the exact same. It would be awesome if I could create a filter and have the ability to select it as opposed to manually selecting all of the columns every time. Thanks
-
Create Gantt from End to Start
Hello! As a project manager, I often find myself needing to make timelines starting with my end date. However, I have only been able to make Gantt charts in Smarsheet (with dependencies) that I can change the very first start date and then the durations, but I can't work backwards or change start dates to meet my needs! Is…
-
Creating groups to sub the lack of creating a workspace within a workspace or a workspace in a folde
Hello all, As other have posted in different forums it would be great to be able to create a Workspace within a Workspace or a Workspace in a folder in order to be able to organize a lot of projects better. What I am thinking about doing now is creating a Workspace for each of the Regions in which a project can be created…
-
One sheet, diffrent collaborators
Dear, We would like to use one sheet/workspace. This sheet with be used by different collaborators with different permissions: 1. On Site; 2. Engineering; 3. Project Management. I would like to make one column with the above mentioned. When i add a task to (for example) onsite. I only want them to see the task for On Site,…
-
Question about tracking project budgets in Smartsheet
Hello all, I'm working on a task where I have multiple project budgets that we want to track in one sheet. I thought the best way to do this would be by using individual sheets and then running a report to include data from each sheet but our Finance department is asking for a way to do multiple jobs (projects) and…
-
HELP - FORMULA - equal to AND IF/THEN
Final Decision (WEBFORM) is a hidden column with the webform results in Yes, No, Hold symbols I need a combination formula for "Final Decision" column: 1. To equal the results in "Final Decision WEBFORM" column 2. AND IF "Final Approval" Column is checked, then show "Yes"
-
Planview Integration
Hi, Has anyone tried or successfully pulled data from Smartsheet to Planview or any other PPM systems? If so I would be very interested to hear what the requirements were and how it was achieved. Many Thanks Paul
-
DEPENDENCIES FORMULA IN TO A PROJET SHEET
HELLO; I HOPE YOU CAN HELP ME WITH THIS PROBLEM: I NEED TO SCRATCH A FORMULA TO GENERATE DEPENDENCIES AUTOMATICALLY IN A PROJECT SHEET WITH THOUSANDS OF ROWS. EACH ROW CORRESPONDS TO A TASK REPEATED RANDOMLY. AND MY PROJECT HAS MORE THAN 70 DIFFERENT TASKS, SO IT IS VERY LABORIOUS TO ASSIGN DEPENDENCIES USING FILTERS BY…
-
Relationship between the "Status" column and other columns
I'm relatively new to Smartsheet, but it seems strange that the Status column appears not to have any relationship to other columns in the project sheet. But maybe it's possible to use a formula somehow to do that? Some specific questions: * If I change a task from Not Started to In Progress, can I set up Smartsheet to…
-
Adding a Hyperlink to a Web Form
Hi All I'm wondering if there is a way to insert a hyperlink as a default value either into a column or a web form so the user than click the link but doesn't have to create the link in every row populated by the web form. I see a hyperlink can be added directly to a sheet, but my users aren't happy with that. They're…
