-
Create table for Risks&Issue register
I have a risks&Issues register sheet and would like to create a table in a new sheet which categorizes based on Streams and risk/issue rating. How do I do it. Attached is the sample. I would like separate tables for risks & issues
-
Live Data Link not working for Date Fields
This is day two of an issue that we are experiencing where our live data link to Excel is linking every field except date fields. Hoping there is a resolution in process for this issue. How do we submit a ticket for performance issues? Thanks, Ken
-
Changed Duration Time for Report
Hi, I just updated a couple of my sheets and changed the duration time to "0" to reflect a milestone. When I run my milestone report these changes are not updated. Is there a delay for some reason. I thought that updates once saved would be immediately reflected. -Laura
-
Custom Output based on Multiple Variables
Hi - I'm relatively new, have watched videos and searched articles but I'm stuck. I have 50+ training products and a ton of potential job roles and location combinations. I'm trying to use SmartSheet as a "database" where I can select from a set of criteria and have that spit out a custom set of recommended training…
-
Word Count in smartsheet?
I have a column in my sheet that contains a list of names of people that are attached to that record/row. I would like to add another column that displays the number of words in that column - just a count of people attached. So if the first column says "Jane, Jack, Jay", I'd like the second column to say "3". I can't…
-
Charts From Drop down Data
I have a sheet which lists loads of data on one column there is a selection of option (open, closed, etc....) Is it possible to put a widget or chart on dashboard showing the quantity of each option?
-
Pulling Tasks into a Report Using Multiple IF(AND( formulas in the same cell
My ultimate goal is to pull data into a report from a project plan. I want to pull: * Current tasks (Tasks where TODAY falls between the Start Date and the End Date) * Upcoming Tasks (Tasks where the Start Date is within the next 7 days) * Previous Tasks (Tasks where the End Date is within the previous 7 days) * Late Tasks…
-
Report on automatic email shares and reports
Hi, Is there a way to pull a report of what sheets within Smartsheets are being regularly shared through automatic emails as an attachment? Thanks, Dan
-
A formula for totaling question
I have a sheet that is tracking issues. One column is a category (bug, feature req, UI issue, etc.). The selections are defined in a pull down and isn't free form. I want to create a widget for a dashboard that shows the total number of each category option. It appears I can't do it directly so I thought of building a…
-
Hide login button
I am dealing with people outside my company. I am sending them information in response to their web form submission that I have setup in Smartsheet. I would really like to use the discussion option but that invites them into my sheet, which I don't want. I just want to capture their replies. So I tried using send row but…
