Using Smartsheet

Using Smartsheet

Discussion List

  • Christina Reid
    Answered - Pending Review Christina Reid 34 views 2 comments Most recent by Jacqueline Henderson
    First post 06/09/20,Last post 07/09/20
    Hello - I have three Workspaces for different firms, and in each workspace I have a folder setup for each project. I want to setup a Dashboard to report on the various different projects the executives. I'd also like new folders (new pr…
    Using Smartsheet342
    Christina Reid
  • Yashwant Singh
    Answered - Pending Review Yashwant Singh 12 views 3 comments Most recent by Andrée Starå
    First post 07/09/20,Last post 07/09/20
    HI, Currently working on smartsheet dashboard. as per requirement Dashboard date change automation based on current date. using matrix widget added (8-jul-2020) date in dashboard yesterday but today date not changed automatically. can u…
    Using Smartsheet123
    Yashwant Singh
  • Sarah Mendelsohn
    StorypointsQuestion
    Question Sarah Mendelsohn 14 views 0 comments Started by Sarah Mendelsohn
    First post 07/08/20,Last post 07/08/20
    We are trying to use SmartSheets for an Agile project. We want to use story points to estimate effort and forecast our resourcing needs, rather than dates. However, we also have dependencies in our tasks that we need to track. How would yo…
    Using Smartsheet140
    Sarah Mendelsohn
  • steinkj
    Accepted Answer steinkj 13 views 1 comment Most recent by Andrée Starå
    First post 07/08/20,Last post 07/08/20
    (File) in Report Builder I am unable to select my columns, they do not appear. However if I go in and add a new column it appears? What did I do wrong? I have 7 Columns from the initial Sheet, I do not see any of those, however I added t…
    Using Smartsheet131
    steinkj
  • Lexie Ozolnieks
    Answered - Pending Review Lexie Ozolnieks 13 views 1 comment Most recent by SoS | Dan Palenchar
    First post 07/08/20,Last post 07/08/20
    Hi! I was wondering if there might be a way to display the "attachments" or "comments" column of a report via the report widget when working on a dashboard? Essentially, I would love to be able to see if/when a row has…
    Using Smartsheet131
    Lexie Ozolnieks
  • MONIQUE WALL
    Answered - Pending Review MONIQUE WALL 14 views 1 comment Most recent by SoS | Dan Palenchar
    First post 07/08/20,Last post 07/08/20
    In this updated version of SS I don't see the option for "Today" on the calendar. Has this feature been moved or disabled?
    Using Smartsheet141
    MONIQUE WALL
  • Michelle Rojas
    Form SubmissionQuestion
    Answered - Pending Review Michelle Rojas 16 views 2 comments Most recent by Andrée Starå
    First post 07/08/20,Last post 07/08/20
    If I create a form in smartsheet and someone were to complete the form, can I make it so that multiple people can be notified about the form submission and have access to the information submitted? If so, how do I do that? Can this be done…
    Using Smartsheet162
    Michelle Rojas
  • Zac Baker
    Answered - Pending Review Zac Baker 9 views 1 comment Most recent by Andrée Starå
    First post 07/08/20,Last post 07/08/20
    Part of my job is keeping up with Birthdays Anniversaries, Expiration dates, I can’t figure out a way for my smartsheets to alert me when approaching these days. I have searched all of the “Help” pages but can’t find one that shows me step…
    Using Smartsheet91
    Zac Baker
  • Alisia Gill
    Answered - Pending Review Alisia Gill 35 views 4 comments Most recent by Genevieve P
    First post 07/01/20,Last post 07/08/20
    I've been requested my by executives to create a bubble chart of all the projects in the pipeline to gain a better understanding of priority . The chart will have 4 quadrants, see the attached. I have created columns in my smartsheet proje…
    Using Smartsheet354
    Alisia Gill
  • FrankW
    FrankW 197 views 10 comments Most recent by Michael Pfeffer
    First post 06/28/18,Last post 07/08/20
    Hi, I created a project timeline in SmartSheet. The today's date is indicated with a dotted line in Gantt view as well as a report created based on the project sheet. However, today's date was not shown when I included the report in a d…
    Using Smartsheet19710
    FrankW
  • Dominique
    Formula comparing datesAccepted Answer
    Accepted Answer Dominique 23 views 12 comments Most recent by Stefan
    First post 07/07/20,Last post 07/08/20
    I am very new to Smartsheet and the making of formula's overall so sorry for this question. I want to create a column where it will be highlighted when the date from column x is 4days or less apart from the date from column y. Does anybody…
    Using Smartsheet2312
    Dominique
  • FTKF
    FTKF 191 views 4 comments Most recent by Paul Newcome
    First post 08/22/19,Last post 07/08/20
    Hi,  I am new to smartsheet and I am finding it very useful; except that I can't figure out how to auto-update completion dates.   For example, when I plan out my project, I put start dates, duration, predecessors and who it's assigned …
    Using Smartsheet1914
    FTKF
  • Michaela Kamenska
    Answered - Pending Review Michaela Kamenska 14 views 1 comment Most recent by Andrée Starå
    First post 07/08/20,Last post 07/08/20
    Hello! I have only recently noticed that when I move rows from one sheet to another, the formula doesn't get copied. I have one formula for automatic date calculation where it says "Used in formula on: <unknown sheet>" and …
    Using Smartsheet141
    Michaela Kamenska
  • Yogin Bhatti
    Answered - Pending Review Yogin Bhatti 14 views 1 comment Most recent by Genevieve P
    First post 07/07/20,Last post 07/08/20
    Hi All, We're trying to move our old intranet onto a smartsheet dashboard. One feature of the old intranet was a direct feed of daily comics to start your day with a smile. I'm trying to find some feeds that will serve the same purpose. A…
    Using Smartsheet141
    Yogin Bhatti
  • Pamela Wagner
    Accepted Answer Pamela Wagner 23 views 5 comments Most recent by Genevieve P
    First post 07/01/20,Last post 07/08/20
    I have a project intake sheet that has a column for department resources where you choose the people who work will work on the project so this cell can have from 1 to 12 names in it. I need a report that will pull the names out of that co…
    Using Smartsheet235
    Pamela Wagner
  • Hari Krishnamurthy
    Answered - Pending Review Hari Krishnamurthy 12 views 1 comment Most recent by Paul Newcome
    First post 07/07/20,Last post 07/08/20
    Hi Guys: Need your expert opinion about a sheet that I created as a Template. Users will access the template daily and input data and save the file as a daily file. The daily file with the data needs to be emailed to users in the organiz…
    Using Smartsheet121
    Hari Krishnamurthy
  • Eddie Abasta
    Eddie Abasta 387 views 5 comments Most recent by Paul Newcome
    First post 08/09/19,Last post 07/08/20
    How can I extract a list of unique values from a list on another sheet? I tried doing this as if in Excel but it isn't working quite right. (Image)
    Using Smartsheet3875
    Eddie Abasta
  • Amit Wadhwani
    Accepted Answer Amit Wadhwani 43 views 3 comments Most recent by Andrée Starå
    First post 01/30/20,Last post 07/08/20
    Hi, I have a created a work space with customisation sheets for a client, but now I want to completely transfer that workspace to my client. How do I do that? without having him saving sheet as new? it should be the same sheet, just need t…
    Using Smartsheet433
    Amit Wadhwani
  • Zoe Beattie
    Answered - Pending Review Zoe Beattie 11 views 3 comments Most recent by Andrée Starå
    First post 07/03/20,Last post 07/08/20
    Hi there, I was wondering if it possible to identify who is currently working on smartsheets? We have a number of sheets that we collaborate it and it would be useful to know if my colleagues were also in the sheet to ensure there is no du…
    Using Smartsheet113
    Zoe Beattie
  • Andy.Mott
    Andy.Mott 495 views 13 comments Most recent by Andrée Starå
    First post 02/20/18,Last post 07/08/20
    Hi there, I have set up Smartsheet so that when a Customer Order is fulfilled, the row of the Order is sent back to the Customer as an Order Confirmation. Also, we attach the Invoice for the Customer Order which should be sent back in the…
    Using Smartsheet49513
    Andy.Mott
  • Ankit Kochar
    Ankit Kochar 339 views 9 comments Most recent by Andrée Starå
    First post 07/17/19,Last post 07/08/20
    Hi, Wanted to check if there is a mechanism wherein smartsheet can store the information collected via different forms at different points in time in a single row ? Providing an example below for more clarity -  Lets say we break the cl…
    Using Smartsheet3399
    Ankit Kochar
  • eceisin
    Accepted Answer eceisin 48 views 11 comments Most recent by Andrée Starå
    First post 05/15/20,Last post 07/08/20
    Hi, I'm working on form entry for a survey and I'd like them to rate in a star system. I'm able to change the column type to symbol with stars, but in the form the selection is word based (one, two, three, etc) instead of star selections.…
    Using Smartsheet4811
    eceisin
  • Saroja Hanasoge
    Answered - Pending Review Saroja Hanasoge 11 views 3 comments Most recent by Andrée Starå
    First post 06/30/20,Last post 07/08/20
    I want to automatically create a new smartsheet as part of an automated workflow which gets its name from a cell in the original smart sheet.
    Using Smartsheet113
    Saroja Hanasoge
  • Peter Fonod
    Accepted Answer Peter Fonod 10 views 5 comments Most recent by Andrée Starå
    First post 07/07/20,Last post 07/08/20
    I created approval form and choosen few columns to be shown. But I am not able to define which one will be first, second etc. Even I setup order by adding in sequence I want to show, after it is saved the order is changed. Can you help me…
    Using Smartsheet105
    Peter Fonod
  • Tanya Brooks
    Answered - Pending Review Tanya Brooks 11 views 3 comments Most recent by Andrée Starå
    First post 06/29/20,Last post 07/08/20
    I have several columns that link to other sheets. If the order of the columns in the inbound sheet is changed from that of the outbound sheet, the linked information ends up in the wrong column. Is there a way to rfreeze coumn order?
    Using Smartsheet113
    Tanya Brooks
  • bzgryzek
    bzgryzek 84 views 7 comments Most recent by Andrée Starå
    First post 04/03/18,Last post 07/08/20
    I have noticed on log history that one user has successfully logged in. I have full admin account, can I check his activity since last log in ? 
    Using Smartsheet847
    bzgryzek
  • sahilhq
    Answered - Pending Review sahilhq 12 views 4 comments Most recent by Andrée Starå
    First post 07/05/20,Last post 07/08/20
    Hi, Can anyone please suggest why I may be getting #INVALID DATA TYPE error when using the formula shown below? I just can't seem to figure it out.... =WORKDAY(TODAY(), [SSI - Customer OH Days]@row) (Image)
    Using Smartsheet124
    sahilhq
  • Terri Polman
    Accepted Answer Terri Polman 11 views 3 comments Most recent by Andrée Starå
    First post 07/06/20,Last post 07/08/20
    Can you remove smartsheet branding from forms....:)
    Using Smartsheet113
    Terri Polman
  • Jennifer Murphy
    Answered - Pending Review Jennifer Murphy 21 views 2 comments Most recent by Jennifer Murphy
    First post 07/06/20,Last post 07/08/20
    I have created a folder containing 15 sheets with various links to reference sheets (outside of this folder) and datameshing. The idea is that I can copy the folder, change a cell reference (location) and the new folder will update with t…
    Using Smartsheet212
    Jennifer Murphy
  • Lindsay Volpe
    Answered - Pending Review Lindsay Volpe 16 views 2 comments Most recent by Lindsay Volpe
    First post 07/01/20,Last post 07/08/20
    I'm trying to check a box on my master sheet if the ID number on my master sheet matches the ID number on another sheet and if the status for that ID number is "Resolved." I've tried several approaches but can't seem to get a for…
    Using Smartsheet162
    Lindsay Volpe