-
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…
-
Reporting from two completely different sheets
I have inheritied two sheets that have the same primary column (project name) but the rest of the columns are completely different. Is it possible to combine parts of these into a summary report? I want the report to have one row for each project listed in the primary column. In my current attempt the projects show twice…
-
Report Builder, Using Include and Exclude on Same Column?
Hi, I was wondering if there was a way to get the Report Builder to filter both an include and an exclude in the same column -OR- get it to filter for an exact word or phrase. Example: Filter for a column is set to find all entries that contain the name "john" but that means that a bunch of listings that also contain…