-
USING FORMS WITH pARENT /CHILD ASSOCIATIONS IN SPREADSHEET
Greetings, Below is a screenshot of a spreadsheet that has parent / child associations. I would like to create a form that will allow team members to input the various meetings & Times, they have during the week. 1-can smartsheet automatically put the response in child rows when a parent row( week Day) has been selected?…
-
Need some suggestions with highlighting info on a tracker
Hello everyone, I am looking for some creative support with a sheet that compiles milestones and dates from other trackers to an aggregated sheet with linked cells. The purpose is to share dates/milestones for each project with each column being a different project and the vertical axis being the milestone or deliverable…
-
Form entry/Copy row automation/Row location
Hello all! I am really hoping this is something easy I am just overlooking. The sheet above has a form. When the form is completed the row of information does not populate in the first available row, but a random row typically 25+. The sheet above had the first row populate at 49 and the automation from this sheet to…
-
Reference Entire Sheet AND Filter Rows Where Column Value ="Search Value"
I am simply trying to do the following: - Refer to another sheet (ALL ROWS and COLUMNS) with the following conditions: - Where in Column [STATUS] is = "Done" The RESULT should be: - This new sheet shows all rows and columns from another sheet where Status is Done.
-
Conditionally changing cells
Hi, I'm looking to see if there is any formula(or anything else) I could use to change a cell to a specific pre-defined value, if a different cell is CHANGED TO a certain value. I know that the changed to functionality is available through automation, however the action options in automation do not offer cell changing…
-
sorting by fill color
Hello, Is it possible to sort rows by fill color? I currently have a conditional formatting rule that assigns a color to a row and would like to be able to have those rows grouped together. Thanks.
-
Enhancement Request: Allow changes to Column Type when Conditional Formatting is set
If a column is associated with any Conditional Formatting, the column type can not be changed. This is true even if the Conditional Formatting Rule is disabled. This is true even when changing Column Type from 'like' types, for example Text/Number to Dropdown List. This is an inconvenience, minor at best, severe at worst…
-
When can we expect an expanded color palette for Sheets?
Currently in Sheets for background fill and fonts, there is only the option of 5 shades of 8 basic colors as shown below. When can we expect this to be expanded to a full hex palette like for charts in Dashboards?
-
How can I link two forms from two different sheets to put the answers on one singular sheet?
I want to be able to have two sheets with two different forms, but then I want the two forms to also have one sheet with the answers from both forms so that the answers are combined. Is that possible? If so, could you help?
-
Setting up billing rates in grid view?
As a newbie, I'm trying to set up billing rates in Grid View by job title, but I'm finding the help documentation in SmartSheet lacking (see attached screen shot). Is this even possible in Grid View? Or is Gantt View the only option? Or, is conditional formatting the only approach? Any input or ideas would be greatly…
