-
Dependencies for drop-down menus
Hello, How can I create a drop down menu dependent on value selected on the previous drop-down menu? Thanks Laura
-
Date Fields
I have two date type questions: Question 1 I am looking to auto populate a date field as soon as two other columns are populated. I want the date to remain fixed and not change to 'today' every time the spreadsheet if opened. The Columns Are: Date Part Fitted - this needs the date auto entered when: Part Number Fitted…
-
Cell linking effecting Last Modified date for whole sheet
I have a Main sheet with a cell that is linked to a log sheet to count total rows. whenever a form user adds a row to my log sheet it is updating the last modified date for all the rows on my main sheet. any idea how I can have this stop happening so I can send out a notification for any row that has not been updated in…
-
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.
