-
How to Setup Formulas to Automatically Link & Pull Data from Other Sheets
I'd like to try and figure out how to most effectively and efficiently connect 2 separate smartsheets together, preferably through some sort of smart formula/code. I don't think doing a manual "cell linking" from a cell in one sheet to the next would be very smart or efficient for what I'm trying to do here. I have both a…
-
WBS or PBS in Smartsheet
Has there been any further discussion on implementing this? If I create the hierarchy in a sheet, when i switch to card view, it is not giving me the view of all the "cards" that report to each parent; rather it is sorting by status or assigned to. Any suggestions on how I can work around the system and implement something…
-
Determining top 3 items
In creating a safety sheet for my company, I am trying to determine the top 3 subcontractors with the highest number of infractions. Is there a formula that can determine the top 3, when the sheet has a format like the following: Sub x - 4 Sub y - 3 Sub z - 9 Sub w - 6 Sub v - 11 Sub t - 1 Sub u - 5 Any help would be…
-
Stars Value
How can I convert the 1-5 Stars Symbol into a number using one formula. I have one column Stars and the one with number should be Rating. I also don't know why they chose to have it convert in Excel to Empty, One, Two, Three, Four, Five. Why not numbers? Thanks for any help.
-
Automatic alerts/notifications triggered when tasks are marked as complete
Is there a way to have alerts be sent out automatically notifying the next team member that a dependency they were waiting on is now done based on tasks being marked as complete?
-
Sum hours from multiple sheets based on date ranges
I'm looking to determine how many hours are assigned to specific stage for a given week. Goal being I have "X" number of man hours available for a given week and if I've assigned 300% of that this week but 25% of it next week I need to know I've got shift resources or tasks around. I've got report that shows me all the…
-
formula in linked cell?
I have a "Master" sheet with incremental rows in groups of 16. So Task Name column has Row1toRow16, Row17to33 with the same headings.(SEE PIC 1) I pull info out of this sheet to other sheets. So on another sheet I just want Row1,Row17,Row34 etc entered in. (SEE PIC 2) I have the first one linked to Row1 "Master". Is there…
-
Missing Calendar Data
Hi, I am still in the beginning stages. In calendar view, I seem to be missing some data from my sheets. One of my sheets has all data showing on calendar view, another has half and yet another has none. I assume it's something I'm doing wrong---but what exactly thanks Mike
-
Column Copying
Hi, I have a need to add columns to all of my active project Smartsheets and then I need to create a webform on each of these sheets. Based on other posts I've seen, I cannot copy these columns from one Smartsheet to another so I need to manually add them, correct? Also, there is no way I can copy a webform from one sheet…
-
Smartsheet connectivity issue with Spotfire.
Hello All, I am trying to get data into spotfire using Smartsheet.I followed the below link: http://smartsheet-platform.github.io/odbc-docs/#faq I am not able to retrieve data in Spotfire WebPlayer. The driver logs is as below. CALLER: SpotFire.Dxp.Worker.Host.exe PID_219C:TID_29D8 MODULE: C:\Program Files\Smartsheet\ODBC…
