-
Fixed Cell Reference
I have search the db for answers but likely have my terminology mixed. I have a sheet which is populated by clients via a web form. New entries appear on the 1st line. I want the value in 'Bears 1' to populate in another sheet or on the same, doesnt matter. The specific cell is key as this is the most current value.…
-
Report not Matching Formula Issue
Hi, I have created a report to use on a dashboard for showing the number of job cards to print for our workshop. The report is shown below, and you can see that there are different amount of jobs to be printed for each workshop: You will see on here that there is: * 3x for the FASTRACK Workshop * 10x for the Van Workshop *…
-
How to "actualize" or transfer dependencies of a completed task?
Task A Task B is dependent on Task A Task C is dependent on Task B For some reason, I was able to finish Task B and Task A was getting delayed. How do I: 1. Extend duration of Task A without impacting dates, duration or status of Task B? 2. Mark Task B complete, such that actual completion dates do not change irrespective…
-
Multi-sheet Kanban
We use a checklist with 340 lines. We currently create a new sheet for each project. We would like to create a kanban that links these projects utilizing the highest level of the hierarchy as the lanes (5 lanes) and the next level as dropdowns in the cards (9 at the most.) The third level is where the actual tasks are but…
-
Formulas In Templates Reference to another Sheet
Is there a way to save a sheet as a template that has formula references to another sheet and be able to easily change the reference when using the template? I have a summary and detail sheet that I want to create a template for future use. The summary references the detail. I'd like the Summary sheet to maintain links to…
-
Reference main table to populate a new subset table based on conditions
Hi, I created a workspace that contains a list of project folders (and its respective sheets, reports and dashboards). I'm looking to produce a new consolidated Master sheet based on multiple criteria from each main reference sheet found in the workspace. In the simplified example attached, the new master table must be…
-
Calender based on a report
I want to run a report that pulls data from several different project schedules and tie them together into a overall calendar. Is there anyway to add formatting to a report or to have a sheet mirror the information that is run on the port? I need to either A: Be able to format the calendar on the report(I know that reports…
-
Links in Dynamic View Work Around
Has anyone figured out a workaround to putting links into dynamic view. I am using control center to create a hyperlink to another sheet with display text (for example "West Coast Project List"). This type of hyperlink does not show up in Dynamic View. I am trying to find a work around and was wondering if my best bet was…
-
Jira Connector - Issue Key - Remove HyperLink?
Is there a way to remove the hyperlink for the Issue Key that is brought in to smartsheet via the Jira Connector?
-
using a form to input new data means my formula no longer works.
hi, I am using a lookup formula to find prices for specific things. once a form is used and new information is inputted into the top row the formula says unparseable and the [column name]1 changes to [column name]2. I would like to stay as [column name]1 even when new information is put onto the sheet. Please can someone…