-
Email content
Hey guys, Hoping someone can help me out. Im trying to see if there is a template or a way to create a tab that lets you upload email content i.e. a content image plus word doc/text to a certain newsletter and the person who is looking after that newsletter gets a notification when content has been uploaded. Also the…
-
VLOOKUP data type question
I'm using this vlookup formula to pull back a value from a data sheet. Let's say the value of NUMBER81 is 123456 and when I type in the formula on the desire sheet it returns "No match". When I go to the ACCOUNTS sheet and look at the data there is a value equal to 123456 in Range 1. When I put an apostrophe in front of…
-
Is there a way to display elapsed time for a project?
Hey everyone! I have a project which has the obvious "start" and "end" date columns and Smartsheet automatically calculates the actvity duration. Is there a formula or something which will calculate and display "elapsed" time from start based on the current date? Thanks! Steve Stutz
-
Auto Populating Report or Sheet with New Rows from Master Sheet
Hello- I'm trying to figure out how to automatically pull in new rows (either using cell linking or reporting) from one sheet, while having columns editable from another sheet. For example, I have one sheet that is a master list of all projects in my organization. We continually add new projects to this sheet. Each project…
-
Consolidating several smart sheets in one (appending columns)
Hi. I have several smart sheets with 2 columns, being the first column common to all. What is required is to have an aggregated smartsheet with the common first column and append the second columns of the other smart sheets. I.E Smarthsheet 1 Subject Juan math A physics B Smartsheet 2 Subject Peter math A- physics C…
-
Reference Sheet name in a Formula within a Sheet
I've seen a similar request for referencing the parent Workspace (though I didn't see an answer) but I am interested in referencing the name of the actual Sheet in a cell within that sheet. I am planning on auto-filling some of the task names within a sheet with a name from the first task row (this would be the overall…
-
Hyperlinking
How do I hyperlink to a cell on the same sheet? I would like to click on a cell and be taken to another page in the same sheet.
-
Reference the value of a cell that is obtained through a function
I have cell one that has a function in it say IF(1=1,true,false) and it outputs true. I then want to do a vlookup for that true value, but I keep getting that no such value exists. I assume that's because the cell actually contains the formula rather than the value true. Is there a way to reference just the outputted value?
-
Smarter Dropdown List Manager
Further to a considerable amount of Community requests for a way to Update Dropdown Lists in just one sheet, then have that list Automagically populate all the other Smartsheets that reference that list. Our Developers, using the Smartsheet API have created just that solution, in fact we have assumed that users will want…
-
Hyperlink to a row/cell in the same sheet?
I am working on an "issues log" in smartsheet and I want the ability to respond to duplicate issue by marking it as duplicate (checkbox) and the next column (Duplicate Of) place the auto numbered row number of the duplicate issue. I would then like to put in the next column (Duplicate Link) a hyperlink to jump to that row.…
