Using Smartsheet

Using Smartsheet

Discussion List

  • Lisa Krieger
    Answered - Pending Review Lisa Krieger 14 views 1 comment Most recent by Andrée Starå
    First post 07/30/20,Last post 07/30/20
    I have a workspace that contains 104 sheets that is tracking the collection of documents that are uploaded to specific rows within the individual sheets. How can I create a report that tells me which rows are not completed on each sheet?
    Using Smartsheet141
    Lisa Krieger
  • Nicole Campbell
    Answered - Pending Review Nicole Campbell 44 views 5 comments Most recent by Gabriel V. Cunha
    First post 03/11/20,Last post 07/30/20
    I have a column that I'm setting to the type of Auto-Number/System that I'm setting to Created (Date). Some time later, it changes itself back to a regular Date column. I've re-set it numerous times and it keeps happening. Each time, I …
    Using Smartsheet445
    Nicole Campbell
  • Gil Nash
    Answered - Pending Review Gil Nash 28 views 2 comments Most recent by Gil Nash
    First post 07/27/20,Last post 07/30/20
    Client submits file through form. I have an automation set up to respond to client when new file w/response is attached to row and "Status" and "Date" cells @row are populated. It works as intended but relies on peopl…
    Using Smartsheet282
    Gil Nash
  • Antoinette Arcella
    Answered - Pending Review Antoinette Arcella 11 views 2 comments Most recent by Genevieve P
    First post 07/30/20,Last post 07/30/20
    Just wondering if there is any possible way I can apply logical formatting within a sheet? ie I have several drop down columns and I want to be able to select one and the responses will be trigged within the other columns. If 'not yet star…
    Using Smartsheet112
    Antoinette Arcella
  • Nigel Michell
    Resource ManagementAccepted Answer
    Accepted Answer Nigel Michell 19 views 2 comments Most recent by Nigel Michell
    First post 07/29/20,Last post 07/30/20
    If multiple resources are assigned to a Task, and the % Allocated is different for each resource, I assume that the only way that this can be correctly recorded in Smartsheet, is to duplicate the Task a number of times so that each Resourc…
    Using Smartsheet192
    Nigel Michell
  • Petr
    Answered - Pending Review Petr 94 views 2 comments Most recent by John Gaglioti
    First post 02/25/20,Last post 07/30/20
    Please check picture below. I would like to create similiar diagram. (Image) Thank you in advance.
    Using Smartsheet942
    Petr
  • Charles L
    Answered - Pending Review Charles L 11 views 3 comments Most recent by Genevieve P
    First post 07/29/20,Last post 07/30/20
    I am getting errors when attempting to invite a user to smartsheets. The error "[email protected]" is currently a licensed user in Smartsheet. To add them to your account, grant them a license" I do not want to grant them…
    Using Smartsheet113
    Charles L
  • Matt K
    Answered - Pending Review Matt K 26 views 1 comment Most recent by Matt K
    First post 07/29/20,Last post 07/30/20
    Hi, The ability to use forms and the logic options are really amazing tools. I see how the use of forms can increase the productivity of my team and eliminate a lot of emails back and forth with our clients. One use case we have is that …
    Using Smartsheet261
    Matt K
  • Ronan Lesage
    Answered - Pending Review Ronan Lesage 15 views 1 comment Most recent by Genevieve P
    First post 07/29/20,Last post 07/30/20
    Hello, I want to set up a form for several kind of requests. Once a request is created with the form, the idea of the automation I want to set up is to send an approval email to a first person, according to the type of request initially ch…
    Using Smartsheet151
    Ronan Lesage
  • Alisa Zimels
    Answered - Pending Review Alisa Zimels 11 views 1 comment Most recent by Paul Newcome
    First post 07/30/20,Last post 07/30/20
    We planed a rough schedule for our project. Now we need to plan new, because of the changes in the project. Also we want overlay the old plan with a new one so we ca see consequences. So I could see it is possible to add new columns and ch…
    Using Smartsheet111
    Alisa Zimels
  • Alyson O'Donnell
    Answered - Pending Review Alyson O'Donnell 22 views 4 comments Most recent by Genevieve P
    First post 07/28/20,Last post 07/30/20
    Hello I am trying to pull 2 different cross sheet reference formulas. 1.) SUMIF({Auto QA Checklist Range 2}, CONTAINS([Agent Name]1, @cell), {Auto QA Checklist Range 6}) _ I need this result to account for an AND statement, that pulls in…
    Using Smartsheet224
    Alyson O'Donnell
  • Jakub Sollich
    Answered - Pending Review Jakub Sollich 22 views 2 comments Most recent by PPS Solutions
    First post 07/23/20,Last post 07/30/20
    I'm seeking the ability to autiomatically fill the drop down list from another smartsheet. Is it possible?
    Using Smartsheet222
    Jakub Sollich
  • JenM.
    JenM. 1.1K views 7 comments Most recent by Paul Newcome
    First post 02/06/19,Last post 07/30/20
    We are having a problem where accidental sorting occurs on a sheet used by several users, and I am looking to only allow users to enter data into a cell, but protect the placement of columns and rows. In my research I can not see a way to…
    Using Smartsheet11377
    JenM.
  • Jignesh Desai
    Answered - Pending Review Jignesh Desai 15 views 1 comment Most recent by Genevieve P
    First post 07/29/20,Last post 07/30/20
    Hello All, I'm managing a portfolio of 100+ projects. I am grouping them under various categories. Some projects will fall under multiple categories. Is it possible to display them in a SmartSheet Dashboard? For example, please consider be…
    Using Smartsheet151
    Jignesh Desai
  • Alice Volante
    Answered - Pending Review Alice Volante 16 views 1 comment Most recent by Genevieve P
    First post 07/28/20,Last post 07/30/20
    Hi Team, I would like some help with my latest issue. I want to create a formula that pulls the name of a project if the column called "feedback received" is marked "yes". Can anyone please help me? Thanks a lot, Alice
    Using Smartsheet161
    Alice Volante
  • luke_dubas
    luke_dubas 253 views 8 comments Most recent by Genevieve P
    First post 09/28/19,Last post 07/30/20
    I searched but didn’t seem to find the issue I’m having posted previously. I would like to set up automated alerts to individuals (contacts) based on a date triggered event however the base sheet has way, way more information than is nece…
    Using Smartsheet2538
    luke_dubas
  • Rebecca Larkin-Martinez
    Answered - Pending Review Rebecca Larkin-Martinez 59 views 11 comments Most recent by katfooddfw
    First post 03/13/20,Last post 07/30/20
    Use case. 4 sheets Intake Sheet, Prioritization sheet, Resource sheet & Overall Status Sheet When a project is requested it is automatically added to the "Intake" sheet through the form. Status field is New. When we agree th…
    Using Smartsheet5911
    Rebecca Larkin-Martinez
  • Julie Rhodes
    Answered - Pending Review Julie Rhodes 10 views 1 comment Most recent by Paul Newcome
    First post 07/29/20,Last post 07/29/20
    We have recently had a hack into our computer system and an entire sheets content was deleted. Is there a way to restore the sheet entirely?
    Using Smartsheet101
    Julie Rhodes
  • SteCoxy
    Answered - Pending Review SteCoxy 21 views 1 comment Most recent by Paul Newcome
    First post 07/29/20,Last post 07/29/20
    Hello, I've had a colleague come to me with a query about how best to link 2 sheets. Her enquiry includes a handy diagram: (Image) I'm wondering if cell linking would be best bet here? I realise this would obviously require her to keep hav…
    Using Smartsheet211
    SteCoxy
  • Lynn Hames
    Answered - Pending Review Lynn Hames 16 views 1 comment Most recent by Genevieve P
    First post 07/27/20,Last post 07/29/20
    We are sharing a dashboard to work colleagues via Workplace that don't have access to smartsheet at all. When you click on the link on a mobile device the dashboard is not mobile responsive and very difficult to read. Is there a way around…
    Using Smartsheet161
    Lynn Hames
  • Loann McGee
    Answered - Pending Review Loann McGee 14 views 3 comments Most recent by Genevieve P
    First post 07/27/20,Last post 07/29/20
    Good morning, I'm trying to find out how to export directly from Smartsheet to a .csv format. I found this article, but it seems to be out of date as I don't see the csv option (not to mention the location of where to access the export are…
    Using Smartsheet143
    Loann McGee
  • Lori O'Daniel
    Accepted Answer Lori O'Daniel 14 views 5 comments Most recent by Andrée Starå
    First post 07/29/20,Last post 07/29/20
    As the Question above reads. I have a Dashboard I am creating as well as some specific sheets. The sheets can be saved as a Template. But, I do not see an option for the Dashboard. If Dashboard cannot be saved as a Template. Does that mean…
    Using Smartsheet145
    Lori O'Daniel
  • Tania M.
    Answered - Pending Review Tania M. 24 views 1 comment Most recent by Genevieve P
    First post 07/24/20,Last post 07/29/20
    Hi, Is it possible to update the information of a Sheet by replacing it with a new version of the sheet. In our current process, we have daily approvals, however by using an approval request or an update request, requires a lot of effort…
    Using Smartsheet241
    Tania M.
  • Chuck Davis at Bates
    One to Many ReportAccepted Answer
    Accepted Answer Chuck Davis at Bates 18 views 3 comments Most recent by Genevieve P
    First post 07/23/20,Last post 07/29/20
    I have created two smartsheets 1.      KeyHolderList 2.      KeysIssuedList The KeyHolderList contains the following columns: ·        EmployeeID (primary) ·        FirstName ·        LastName The KeysIssuedList contains the following col…
    Using Smartsheet183
    Chuck Davis at Bates
  • Melani Coetsee
    Answered - Pending Review Melani Coetsee 15 views 1 comment Most recent by Genevieve P
    First post 07/22/20,Last post 07/29/20
    Our company has 2 accounts One account @ $xx per license with a set number of users and A second account @ $yy per license with a different number of users We are unable to upgrade just one person in the first group from a $xx license to a…
    Using Smartsheet151
    Melani Coetsee
  • Marilu Yanes
    Answered - Pending Review Marilu Yanes 24 views 9 comments Most recent by Paul Newcome
    First post 07/28/20,Last post 07/29/20
    How can I link a group of cells on a row to populate in a column ? Resource sheet (Image) Destination sheet (ignore the numbers) (Image)
    Using Smartsheet249
    Marilu Yanes
  • Chuck Davis at Bates
    Data Storage ConflictAccepted Answer
    Accepted Answer Chuck Davis at Bates 21 views 5 comments Most recent by Paul Newcome
    First post 07/23/20,Last post 07/29/20
    I created a sheet by importing from an excel file. The primary column (EmployeeID) was stored as text upon import even though it was stored as "number" in the excel file. Subsequent data input from either a Form or manual inpu…
    Using Smartsheet215
    Chuck Davis at Bates
  • Noah Fenley
    Answered - Pending Review Noah Fenley 16 views 15 comments Most recent by Paul Newcome
    First post 07/27/20,Last post 07/29/20
    My customer is looking for a chart to demonstrate weekly progress across several projects. All she wants to see is the project name, percentage and the weekly date. I am struggling with a clean way to provide the top level information from…
    Using Smartsheet1615
    Noah Fenley
  • Benjamin Chua
    can created by be change?Accepted Answer
    Accepted Answer Benjamin Chua 10 views 5 comments Most recent by Paul Newcome
    First post 07/29/20,Last post 07/29/20
    so i have users entering data and it records their email address as created by, but sometimes a record is not being recorded and admin will fix it. it shows the admin's email address in created by, how do send an update to the users so th…
    Using Smartsheet105
    Benjamin Chua
  • Cheryl Camacho
    Answered - Pending Review Cheryl Camacho 14 views 2 comments Most recent by Genevieve P
    First post 07/28/20,Last post 07/29/20
    Is it possible to create a hyperlink to a Smartsheet folder, rather than a Sheet, that I could put in my Dashboard? Thank you.
    Using Smartsheet142
    Cheryl Camacho