-
Check box from Child row to Parent row
Hello, I'm looking to filter out a Parent row and all Child rows that have a drop down with a certain value, but with a twist. For instance, if a Parent row has a Status drop down value of "Completed" then that Parent row and all Child rows (regardless the value in Status drop down in the Child row) to be filtered out.…
-
How do I get an email notification when someone makes a comment?
Hi everyone I'm perplexed that the comment feature doesn't allow you to notify specific collaborators when commenting on a row. How does one know when a comment was made and specifically if directed @ them? Anyone have any suggestions how to make this work?
-
Reference a value from 1 sheet in a formula
Is there a way to reference a specific value from one sheet into a formula on a different sheet. For example Sheet 1 Row 1 Column 1 has a value of 5 Sheet 2 would like to reference Sheet 1, row 1, column 1 in a simple SUM formula =SUM(Sheet1:Row1Column1+Sheet2:Row5Column3) If Sheet 1 Row 1 Column 1 has a value of 5 and…
-
Summing Values
Currently I have a Spreadsheet that catalogs potential software enhancements. In order for us to determine prioritization we use a spreadsheet to calculate results based on a rating of 1-5 based on 6 criteria. We also assign each criteria a weight as some of the criteria is more important than others. I'm trying to create…
-
Linking within same sheet
I have a sheet with numerous calculations, one being a constant for "invalid" and a number. Instead of having to key in the number for invalid in each of the computations, I was trying to link to single cell where I would key it in once. I can link to other sheets but not the same sheet as in Excel with + feature. Does…
-
Summary Reporting from a Single Smartsheet
I have a single sheet used to log test defects. From this sheet I've created a summary section at the top for Open Items and Items by Status. I need to create another summary "Item Status by Sprint versus Production". I've tried Reports but this does not allow adding a summarization of the data (equivalent to an Excel…
-
Conditional Formatting on Linked Sheet
Hi Guys I have a sheet that is a programme sheet which holds all the high level data of each project within the programme of work. I have a cell called budget variance which I want to be formatted as filled red, large bold text across the whole line. I want this to occur when the variance data is more than £9999. Currently…
-
Formula: Count amounts together by specific date range
Hi, I've tried to fix it myself but I'm not getting it anymore. I want to count together on a specific date, which differs at a time. = SUMIF (Due Date) 1, [Due Date] 5, YEAR (@cell) = 2014, Cost1: Cost5) is based on year but I would like to select for example on 04/01/2017 to 04/20/2017 . I hope my screenshot makes sense.…
-
Upload Files - Upload Window Obstructs the View
When uploading files, I have to upload one at the time and then wait until the first file has been uploaded before I start with the 2nd file, because the Upload Window is covering the entire screen!! It did not use to be like this a few years ago. This is really, really slowing down my work. Is there anyway this window can…
-
Auto numbering
Hello, is there a plan to add a function for "auto numbering" in smartsheet in the future? 1. title 1.1 sub-title 1.1.1 sub-sub... I'm using it for project management and strategic planing and it would very usefull! Jack
