-
Reporting and dashboard help
I have a smartsheet containing work experience for every person in our company. The rows go something like this... * Steve Smith | Project Manager | Company A | 2.5 years | etc... * Steve Smith | Project Manager | Company B | 1.5 years | etc... * Steve Smith | Project Coordinator | Company B | 5 years | etc... * Karen…
-
Trying to Hyperlink an Email address
Hello! I am doing by best but cannot seem to figure out a way to hyperlink and email address within a cell so that it can immediately open a blank email if clicked. Is that possible? Thanks for your help!
-
Programatically select a subset of a column
I want to be able to average, or other function, over a subset of the cells in a row. The number of cells I want to include is specifiied in a separate cell. In Excel, I accomplished this with OFFSET. I read another article here noting that smartsheet doesn't have OFFSET, but that MATCH and INDEX might be able to be used…
-
Integrating Smartsheet and Comments in Google Docs & Google Sheets
There is a great, simple comment thread feature in Google Docs and Google Sheets that I am finding very useful working with teams. You can also do notification with a plus sign and someone's email address (+jane@abc.com) as well as task assignment to one of the people whose email address you have added to the comment…
-
Named ranges in a formula not "actively" importing from cells expire.
I folks. I think I found an edge-case in your new cross-sheet formula system. I wrote some index formulae to pull related data from other sheets when the user chose some options from a list. All was working, and I was able to link, customize and test the named ranges. I got my two sheets converted to the new system and was…
-
Remove Cell Linkage
I had previously created a sheet that inputted data via cell linking. However, the use of that sheet is no longer needed so I deleted it. The problem is that the sheet that was 'pushing' the data still shows the outgoing cell link. How can I remove the cell linking?
-
Remove Outbound Links to Unknown sheet?
Hi, i changed some sheets around in a workspace and ended up with a bunch of outbound links to unknown pages. is there a way to remove all outbound links to unknown? or am i stuck going one cell at a time and deleting? thanks
-
sum with new vlookup sheet reference
I have this formula copied down a column: =vlookup(A1,ReferenceAnotherSheet,3). The first row bring back the correct number value. The other rows are bringing back a #nomatch. Also, I want the cell to return the total of all cells in column 3 that contain the cell referenced in A1. I know I need to use sum or sumif, but…
-
Link sheets so when "checked" it adds to another sheet
Hello, Is there any way that I can use a check box to then add an item to another sheet? Thanks, Harrison
-
VLookup Range Changing - UPDATED - RESOLVED
I have a sheet of VLookups which I get to be working perfectly then when I come back later (sometimes as little as 10-15 minutes) most cells have been changed to "No Match". To fix this I simply have to re-input the range to what it has been the entire time. If this is how it's going to be it makes this feature practically…
