-
Formula to make a metrics sheet to build a pipleline dashboard
I have a sales tracker sheet and need to continuously pull data as new quotes are formed to show wins/ losses compared to our target in a dashboard. Sheet has 3 columns that need to create the formula: Account type, Weighted Forecast, and Expected Quarter Close. In real words, I want to say Weighted forescast is $1M for…
-
Trying to Join Multiple Rows to one cell
I am trying to combine all of the data into one cell for a row, but also any additional rows that share the same PO #. I then plan on taking this information and moving it to another sheet in order to set up Shipping and Delivery notices. I am still pretty new to smartsheet and I have tried googling and watching videos on…
-
Converting Cell Text to Hyperlink
Hi. I have a formula in a cell that generates the name of a course using text from other cells (e.g., BUS-430-BL-6W-1D-Master). FORMULA: =LEFT([Subject + Course]2, FIND(" ", [Subject + Course]2) - 1) + "-" + RIGHT([Subject + Course]2, LEN([Subject + Course]2) - FIND(" ", [Subject + Course]2)) + "-" +…
-
Copy to other Smartsheet when row is added or UPDATED
I have two sheets, lets say A & B, which are currently blank and will be used to gather patient information. I'm trying to copy anything entered in sheet A to sheet B including if an updates have been made (e.g. if a name is entered incorrectly in sheet A and later corrected, sheet B will be updated in the same row and not…
-
Mapping Data Mesh Sums from a Report to a Sheet
Hello, I've done a bit of preliminary research but haven't seen a similar issue discussed. While I know Data Mesh can bring data from a report to a sheet, is it possible to use it to bring over sums from a report into a sheet? I have a report which includes line-level financial data and have grouped that data by cost…
-
can i auto-populate/create rows on another sheet if a cell on another sheet changes?
In this case, I'll populate a scheduling sheet as seen on top, this will then ideally show up on the 18th of Dec (if it's scheduled on the 18th) as separate rows if possible. Not sure if smartsheet is able to do something like this so would like to get possible help or input? So far i've tried using smth like…
-
Formula for Cross-Sheet References Based on Row/Task Information
Is there a way [in the Core App - without Control Center] to create a formula that pulls in data from another sheet via cell linking, but is set up in a way that it can be used in a repeated use template? To give an example of what I'm trying to do: I have a set of projects that are fairly consistent as far as activities.…
-
Please add "Select an Existing Sheet Reference" option when creating formulas.
When creating a formula you're given the option to "Reference Another Sheet". I love this feature but it needs improvement because it ONLY gives you the option to create a new reference. Yes, you can click the same range as an existing range and it will auto-populate with the correct range number, but that's only if you…
-
Merged: Dynamically Update Column References
This discussion has been merged.
-
Sheet Relationship Diagram
Is there a report I can create that will identify and map out all of the sheets that are linked to other sheets? We have hundreds of sheets, and quite a few workspaces. We regularly link one sheet to another so they all stay updated, but it can be hard to capture where everything is linked. For example, we have a resources…