-
How do I link a project worksheet into the row of a separate worksheet?
Hi, I'm new to Smartsheet and hoping to find a solution to the following: How do you link a worksheet to a row of another worksheet? For example, I have a worksheet for my Master Project List that lists about 70 projects. Each project has a separate worksheet for its individual project tasks/deliverables. I am hoping there…
-
Deadline column from Creating A Master Calendar video...
In https://learn.smartsheet.com/master-calendar, the presenter uses "Gantt Project With Hard Deadline" template to create projects, then in Report Builder uses the "Deadline" Column for filtering. However, when I use this same template, there is no "Deadline" column, nor is there a "Deadline" column available from the…
-
Using Lookup Function
Hi, I am a new user to Smart Sheet. I am trying to use the lookup function for a value in another Smart Sheet. I want to search for the name in the current Smart Sheet over in another Smart Sheet and when a match is found, get the value in Column 6. I have searched the help section but can't find an example of the lookup…
-
Referencing formula for other sheets?
Is it possible to build a formula that references other cells/sheets into a new sheet? I am trying to create a sheet that would sum values from another sheet into a new one to build some stats. Because the source sheet is generated using the SmartSheet/JIRA connector rows are automatically and constantly being added, so I…
-
Automatic Quarterly Reminders?
Hi there! I am building a database to monitor multiple cashflows and am tying to figure out the best way to set up an automatic reminder for the person responsible for each cashflow to update financial information on a quarterly basis. I was thinking of creating reminder date columns (and hiding them) for each quarter. Is…
-
Project Health Based on task completion vs project completion
I am trying to determine a way to communicate/graphically represent project progress based on today's date in relation to the start date and projected end date of a project. So if we have a 90 day project and we are on day 50 I want to see Project Progress of 55% I already have a data point for Task Completion percentage…
-
Formula Inquiry
I am trying to get a formula to automatically apply a number (vehicles complete column) when a date is filled in from a linked cell in another sheet (completed column), see attached photo for reference. The cell I want to be auto filled has a sum children formula already in place. Is this possible and if so do you have an…
-
While moving row to new smart sheet it re orders to a new column.
Why is it linked to this new column how do I change it. It is greyed out on my sheet. I have all admin rights
-
Store cell data on specific date
Hello, I'm needing some help in figuring out if it's possible for smartsheet to pull data to a cell on a specified date. For example I need to hire 5 people for a building opening on 12/1/2018, but they need to be hired 8 weeks prior. What I want to do is have one cell that takes the hired count cell and pull the info on…
-
Project Sheet dates
Is it possible to use Month 1, Month 2, Month 3, etc. instead of actual date names (Jan, Feb, Mar) in the heading?
