-
RYG Symbols in Child rows to update parent row
Hi, I am looking to populate the status of parent row to symbol: Red, Green, Yellow Parent Row: Red Symbol = If ALL child rows are red symbols Yellow Symbol = If ONE of child row is yellow or green or all child rows yellow (child row may contain red) Green Symbol - If ALL child rows are green I created this formula but…
-
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?
