-
Duplicate Values Returning in Search Results When There's Only 1 Unique Instance of the Value
I use SmartSheet to track projects (courses) that my team creates. Each unique course and lesson title is listed in the Project column. When I do a search for a project, the same project name displays twice as 2 rows with 2 different last modified dates. When I select each one of the projects in the search, they each go to…
-
Summary Formula
Hello, I am using Smartsheet for project planning. I would like to track adherence to plan, specifically counting the average of the Start to Plan and Finish to Plan and represent the number separately as a percentage so I can see what percentage we start and finish to plan when it happens. I have created an Ancestors…
-
Using Smartsheet Forms as multi lingual survey tool
Hi, I am using the forms function to collect data from people in many different countries. The information we are collecting is in binary, single select, and multi select formats. This information is being summarized in a separate sheet, where we are counting the instances of each response from the binary, single, and…
-
Project Planning: Percentage Complete from Dates
Hello I'm currently using Smartsheet for project planning. I want a forecasted percentage complete on progress to date from baseline start to baseline finish. Can anyone help please? Thanks in advance! :)
-
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.
-
Create a backlog item when status changes in a form?
I created an intake request form and it has a status field that on submission is set to Submitted as default. A email is triggered to the team that a new intake was submitted. The process then requires someone on the team to review it and set up a discovery session. Is it possible when the status changes from Submitted to…
-
Attachments (PDFs) opening in web browser, not default PDF reader - how to change preference
Our attachments in Smartsheet which are usually always PDFs, used to open in my default PDF app - I have just upgraded computers and now PDFs open in my web browser?! Which I don't want. How do I change the preference to open these attachments in the PDF reader of my choice?
-
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
