-
Multi-Select Values won't print!?
I used the new Multi-Select function in my sheet and I love it. However, I can't get the second value on the line to print. It's only printing the first value selected. EX: "Responsible" Column: Joe Smith and Jane Numbers were both selected as the responsible individuals for a specific task. On the sheet, they are both…
-
Formula For Finding Quarter
Hello, New to smartsheets I have been using excel extensively. Can someone pleased teach me the formula for finding a quarter based on a date? For instance [Date Data Column]1 = 1/1/2016 I want the formula to return "Q1" in the [Quarter]1 cell Havent been able to figure this one out...help please!
-
Inventory
Is there a training video to show us how to do the inventory and features? We want to use this feature but I need some training.
-
Recording the date of a specific update and locking that date?
Greetings SMARTsheeters... Not sure if what I'd like to do is possible in SMARTsheet, but here goes... I'm working on a SMARTsheet that receives data adds and modifications from SMARTforms and autoupdate email requests. There will be various users entering and modifying the data in the SMARTsheet adhoc through these forms…
-
Master Sheet with Subprojects Inside
Hi! I am trying to create a Master Project sheet that would include subprojects inside of the same sheet. Basically so I can track the dates and overlapping of tasks in the subprojects. Is this something that Smartsheets can do? I know I can do it in MS Project and just add each subproject as it's own task in a master…
-
Apply Formula to Entire Column
I'm trying to automatically apply a formula to an entire column that concatenates info from cells in a given row into a document name, once data is entered into those cells. The only way I've been able to accomplish this so far is to just copy/ paste or drag the formula as data is entered in a new row, but I'd like it to…
-
Help! Percent Complete not calculating
I have a project plan that was sent to me in a Excel spreadsheet that I'm trying to import into Smartsheet; after some trial and error, I've fixed up the fields but even with duration, start, end date and predeccesors enabled, I cannot get the % complete column to populate.…
-
Column descriptions - display
Is there a way to keep column descriptions displayed instead of having the user hover over the icon?
-
Conditional Formatting with multi select dropdown list
When using Conditional Formatting, I want to make my primary column change colors when a combination of choices are made in a multi select dropdown,. What it looks like now is this: If column 2 is 'condition' and column 3 contains 'condition one' or 'condition two' then apply this format to the column one Is there a way to…
-
Limited Availability on drop downs in forms
Hi, relatively new user here - I am wondering if there is a way to make a drop down option limited? Like for appointments or meetings? example: Choose a time slot - but only ones that have not yet been chosen will display? Any help is appreciated!
