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 …
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 …
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 ce…
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 …
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 cond…
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 thi…
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 …
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. Som…
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 ro…