-
How to efficiently link data from one sheet to two other sheets
Hello, I'm trying to link data from a master sheet to two other sheets. Here is what I tried so far, but it's not working. Created a form on the Master Sheet. Tried Cell linking the master sheet to two other sheets. However the problem that I have is that because I am already using cell linking on this Master sheet to feed…
-
Referencing a cell on another sheet based on information in its' parent
Hi everybody, been melting my brain trying to get this one I have a bunch of project sheets set up to send their rows back to a central tracking sheet. I have a Master Status sheet that parses that tracking sheet for each project. It looks up a unique project ID, parses that central tracking sheet for the latest row with…
-
Duration to a specific task from project start / counting the number of project days
Hello, I'm wondering if there is a function in Smartsheet by which I can create a column that displays the total number of project days from the beginning of the project ("Project Day 1") up to the beginning of each task. For example, the first task would start on "project day 1," the last task of the project would start…
-
Are you able to associate answers with number values?
I am attempting to create a form similar to the one attached below: Is there a way to associate the answers a user inputs on the form to a number value and then add them up to a total? Thank you for the help in advance!
-
Tracking % Changes Over Time
I have a master sheet (linked to many other, scope-specific QC sheets) that calculates % completion per task. Each row is for a different task, and each task has their own amount of steps. This information is all linked & calculated from the scope-specific sheets. Column 1 shows "# of steps completed to date", column 2…
-
Formula to Arrive Todays date
Is there any option today reflect today's date in smart sheet. I tried typing =TODAY() in smart sheet cell and returned with #INVALID COLUMN VALUE Its similar to MS Excel I used this formula in the cell I require
-
Can Index Match pull multiple records?
I am trying to pull contract numbers from an Active Contract file over to a 2nd file using the customer name as the unique identifier which is working just fine via INDEX(MATCH), however, if a customer has more than 1 active contract it only pulls the first one over. What's the best way to pull all of the contract numbers…
-
Cut not working
Starting 7/30/18 we noticed that using either the keyboard shortcut or the right-click option to cut a line within a SmartSheet would sometimes leave behind the original line (acting more like copy than cut) when moving to a different place in the SmartSheet. Two people within our organization have recreated the problem.…
-
Formula in a date column
I am trying to use the vlookup formula into the scheduled date column that also has dependency on predecessors. When inserting the formula into that column, the formula does not override that dependency. Is there a workaround to this?
-
Yielding blank cells
Hello, I'm using health circles to indicate progress. However, I want the circles (green, red, yellow, and gray) to show active stages in the process (complete, incomplete, in progress, on hold, respectively). I want phases that are not yet started, because the start date has not yet started or is not yet set, to remain…