functionality
Discussion List
-
Tracking date when a drop down value is selectedIn Formulas and FunctionsI'm creating a project tracker where I can assign what phase the project is at (design, prototype and complete). What I want to do is track how long the project is in each phase, so what I plan on doing is tracking when the drop down items…Answered - Pending Review 13 views 2 comments 0 points Most recent by Cole Fuerste Formulas and Functions
-
Pasting Data SetIn Formulas and FunctionsHi, I have a large data set that I paste into Smartsheet from excel for a Dashboard to populate. When I paste some of the data in that's in 1 cell in excel Smartsheet is splitting it across multiple columns meaning I manually have to amen…Answered - Pending Review 2 views 4 comments 0 points Most recent by Maxine Roberts Formulas and Functions
-
Index/MatchIn Formulas and FunctionsI have a smartsheet that has a column for "State" and then a column for "Territory". How do I write a function that if a row within column "State" equals say "TX" than the column for "Territory&…Answered - Pending Review 12 views 3 comments 0 points Most recent by Andrée Starå Formulas and Functions
-
how do you reference a single cell in an external sheet...dynamically? formulas? Cell Linking?In Using SmartsheetThank you for your time. I cant find the answer in the documentation or forum. So I am asking. a. How do I reference a single cell in an external sheet? b. Can I reference a cell by row number and column number? c. Is there a …
-
Keeping track of datesIn Formulas and FunctionsI want the time a specific cell is edited to be automatically placed in a cell. I don't want to use the column setting because that updates when any cell in the row updates and not just the one I want. Is there a way to do this?Answered - Pending Review 2 views 1 comment 0 points Most recent by Andrée Starå Formulas and Functions
-
Can I combine multiple rows into one row on a Gantt Chart?In Using SmartsheetDear all, I want to aggregate multiple project schedules into a master schedule. When copying the milestones from various projects into a single sheet, my overall Gantt Chart displays an event as a row, and each project occupies many rows.…
-
#INVALID DATA TYPE ErrorIn Formulas and FunctionsI am receiving an #INVALID DATA TYPE Error when I have blanks in the dates I am referencing. The formula is summing the equipment pieces based on the delivery month, but the delivery date can be added later in the project, so there will o…
-
Lock or Store Date/Value Solution without using ZapierIn Formulas and FunctionsHi all, I hope you're well and safe! I've developed a solution that lets you store the date or value. You'd use the copy-row automation and a VLOOKUP or combination of INDEX/MATCH to make it work. We'd trigger the copy-row to another sh…
-
Prevent Sorting on Shared SheetIn Using SmartsheetWe have a lot of users using Smartsheet as a tracker. Team members sort and then filter to get the information they need. The problem is that the sort affects all of the other users who are sorting on different things. Is there a way to ha…
