-
Satisfy all requirements; with different formats of columns
Hello :) I need some help :) i think i have a few steps i will need to complete .. however big idea is to be able to make sure multiple columns have criteria matched; then send a notification with an attachment as well as mark a checkbox complete .. initially i think i need to use a countifs formula to tally all columns…
-
% Complete Based on Amount of Tasks, Not Time
Hi, New to Smartsheet, and wondering if there is a way to have the % complete cell calculated by the number of 'child' tasks only, rather than basing it on the amount of time each task takes to complete. For example, if I had 5 'child' tasks below 1 parent task, I want each one to be weighted equally at 20%, regardless of…
-
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…
