-
How can I create new entries/rows and make sure the link's rule applies automatically to them all?
Hello All, I created a mother sheet called Product Development which we populated via it's online form. I created a secondary sheet ( daughter sheet) called Costing in which the majority of the columns are linked to the rows in the mother 's sheet. I added a new last row but the Links to the secondary sheet are missing.…
-
HH:MM sum formula in Smartsheet
I have a series of times that our staff spend on a particular activity for a month in format HH:MM as shown below but I'm struggling with how to create a formula in smartsheet that allows me to sum these values are report the result in the format HH:MM too? Can anyone assist?
-
Referencing the last comment to update a column
Hi Community, I've started a Software Issue tracker and so far I've found ways to display the information how I'd like it. I hit a road block when trying to display the latest comment a field on the spreadsheet. I'd still like to use the comments thread so other Project Stakeholders can reference the communication for each…
-
Excel Sheets as the base content for Dashboards
Hi- I have team members that are very resistant to anything new. They want to continue to use Excel for their spreadsheets and wonder if the Dashboard and other sheets that folks use in Smartsheets can actively link to their Excel sheets instead of actually having a SmartSheet. I know that Tableau does this - it links to…
-
Consolidating output from multiple forms onto a single line in a sheet
I am quite a new user so apologies if this is quite a simple task I have a multi stage process which relies upon collecting information from 3 different sources (for which 3 forms have been developed), but as the information all relates to a single request to procure a vehicle, which is being tracked on a single sheet, i…
-
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!