-
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…
-
Staff Widget Production Tracking
I'm trying to set up a Smartsheet to track the weekly work completed for each staff member and for the overall team. We do invoice processing, which has about 20 different invoice types. We currently have a Smartsheet set up that tracks invoice types in rows. The columns track workload, which includes invoices processed,…
-
Defining a range using a variable as the row #
Hi, Newbie question here. Let's say we have a simple SUM formula: =SUM([Column1]15:[Column4]15) Is there a way to specify the row # using a variable or some kind of reference to a number value in a cell? For example, rather than "15", something like =SUM([Column1]Row:[Column4]Row) where "Row" could be sourced from the…
-
Formulas and Referencing Sheets
So with the new referencing sheets feature (at least I think it's new) is it possible to have one sheet that would be the master for all summaries and metric information rather than roll them up into extra rows at the top of each sheet?
-
Add Custom Image For Trend Widget
Hi, I am able to setup a widget that is link to a direction symbol (up, down, neutral) for my data. What i want to do is have a customer image for each (up,down,neutral). Is it possible to have a conditional statement that will present the relevant image to the widget? I have tried within a sheet, by adding the image to a…
-
Building A Sheet That is Agile Velocity Focused
It won't let me hyperlink a copy of it but here is the URL for those who trust I'm not trying to do anything scary. https://drive.google.com/file/d/0B8APP67r815BaVdmRkxrRlVKRDA/view?usp=sharing So this creates a gant shart that shows them waterfalling off one another (but only shows where they end and not begin) It also…
-
Feature Request: Switch, Vlookup, and/or Lookup Functions
Please add one or more of the following functions: switch, vlookup, and/or lookup. Note that this would make it easier to reference rate categories in a rate table without having to use a huge nested if function.
-
Assistance with a formula -- similar to VLookup
I’m not sure if this is possible in Smartsheet but I know the Community will know! For our Annual Meeting, I created a blank sheet that will help us manage our schedule and assigned meeting rooms. Some of the columns are: * Meeting Room Name (the name of the hotel meeting room) * Capacity-Conference (the capacity of the…
-
Copying Rows
I'd like to be able to add 1 row to multiple sheets at the same time. All of the sheets are from the same template, so all columns are identical. The best thing I have found so far is to create the row, then copy it to 1 sheet at a time, but it's still very time consuming. Any ideas?
