-
Using Smartsheet Merge Add-on for Google Docs Problem
Hi All, I dowloaded the add- on of Google Docs with smarsheet, and I was able to connect it successfully to my relevant sheet in smartsheet, When I tried to add the relevant data to each row in my table, from each row in my smartsheet sheet it created a new table in a new page. Is there a way to embed the data from each…
-
How to prevent the auto adding blank rows ?
Hi all, Smartsheet keep adding new blank rows to the bottom of the sheet even though if they are deleted manually . Is there away to prevent the auto inserting new blank rows ?
-
Improving wayfinding/navigation
Currently wayfinding in smartsheet is quite clunky, as via File > Properties is the only way find where we are located, or to jump to another place in the folder hierarchy. It would be great to have these breadcrumbs surfaced on every page in smartsheet.
-
Why is one sheet workflow bringing the cells to the top and 1 sheet is bringing the cells bottom
I have two sheets that workflow to a separate sheet. One sheet will put the cells at the top and one will be brought to the bottom. How can the cells be workflowed to the top of the separate sheet.
-
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…
-
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
-
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? :)…
-
Using Formula - Display Wednesday of Every Week based on Submitted Date
I have a publication that's sent out every Wednesday and allows people to submit articles to show up in the weekly publication. I need help writing a formula that would make the "Publish Date" column anything submitted between Thursday-Wednesday to show that week's Wednesday date and everything outside to show the…
-
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…
