-
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…
-
Is there a way to use automation across grids?
We're using Smartsheet to track project requests. I'm working to build "personas" to show the type of projects coming in based on the requestors job function. Is there a way I could use automation to add data from another sheet so that once we receive a request the automation can reference the requestor's job function and…
-
Indent using a non-US keyboard
I'm using a keyboard where '[' and ']' are found using "Alt GR + 8", "Alt Gr + 9". How do I indent using the keyboard? "Ctrl + Alt Gr + 9" does not work. I have also tried using Ctrl + M as proposed in another thread. Thanks Lars Bo Wassini
-
Switch Formula
Hello, I have recently integrated a project plan from MS plan to Smartsheet's however I can't seem to get the auto RAG Switch function working working as it was in Project Plan. This is the formula I used. Can anyone please help :) Switch( ([% Complete] = 100), "C", ([Baseline Finish] < Now()), "R", ([Finish] > [Baseline…
-
IF Function
Hi, I want a formula to report if the Actual Start date is greater than the Baseline start then put the tick and cross symbol. The formula works however even when there is no actual start date entered it will still populate. I need a condition for if it is blank then no symbol appears. Can anyone please help me out? :)…
-
Sort feature using multiple columns
I have a project management sheet programmed with predecessors. Sometimes I need to add line items via web forms or "copy to" automation feature. Weh I add these lines, I need the new row to sort into place with the other dates (see images) Image 1 - Sort order of operations - SITE NAME first, START DATE second Image 2 -…
-
Index/Match/Max Function Issues
@Paul Newcome @Andrée Starå I am having issues matching a cell value from my project status column. My goal is to reference my most recently updated (max modified cell) data entry and return that value in the selected cell. My current formula for reference: =INDEX([Project (Schedule) Status]3: [Project (Schedule)…
-
Formula for RYG Symbols in Child Rows to Update Parent Row
Hello, I'm wondering if there's a formula that could automatically update the parent row in a column that has RYG symbols? The parameters would be: -Green overall (in the parent row) if all children rows have green symbols? -Yellow overall (in the parent row) if any children rows have at least 1 yellow symbol? -Red overall…
-
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.
-
Adding a value option for dropdown selections
I have made a simple dropdown column specifying quantity of a product, i.e., pint, gallon. Is there a way I can allow for a value to be added next to each selection, e.g., pint 4, gallon 1. I'm using this Smartsheet as a database of sorts, so it may not be configured for this...
