Using Smartsheet

Using Smartsheet

Discussion List

  • Ken Hallaran
    Accepted Answer Ken Hallaran 7 views 8 comments Most recent by Andrée Starå
    First post 07/09/20,Last post 07/10/20
    I have a dashboard that references a cell in a sheet. That cell contains a formula that displays a value based on date triggers (future, open, past due). My problem is the cell value will only update if I open the sheet and then click s…
    Using Smartsheet78
    Ken Hallaran
  • Laura Tabellini
    Answered - Pending Review Laura Tabellini 10 views 3 comments Most recent by Andrée Starå
    First post 07/09/20,Last post 07/10/20
    I have a person creating Eloqua emails upon request. The requester fills a form with instructions and attachments of the email body. The email body will be sent back and forth for edits between the requester and the person creating the ema…
    Using Smartsheet103
    Laura Tabellini
  • Joachim Mund
    Accepted Answer Joachim Mund 26 views 5 comments Most recent by Andrée Starå
    First post 05/04/20,Last post 07/10/20
    Hi all, I have a project plan with tasks and planned start/finish and actual start/finish How can I visualize them with two comparing gantt bars? Planned vs. actual?
    Using Smartsheet265
    Joachim Mund
  • Jessy Martin
    Answered - Pending Review Jessy Martin 12 views 4 comments Most recent by Andrée Starå
    First post 07/09/20,Last post 07/10/20
    Hi all, A person shared to a sheet (access level Editor - cannot share) is not seeing a parent row: What it should look like: (Image) What it looks like for this particular user: (Image)
    Using Smartsheet124
    Jessy Martin
  • steinbeb
    Answered - Pending Review steinbeb 9 views 4 comments Most recent by Andrée Starå
    First post 07/08/20,Last post 07/10/20
    Hi - We need to publish / share dashboard to all (unlicensed) users in domain xxxx.com, without requiring them to set up an account / request a license.  Anyway to do this?  Thanks in advance... Barry
    Using Smartsheet94
    steinbeb
  • Jessica King
    Answered - Pending Review Jessica King 11 views 3 comments Most recent by Andrée Starå
    First post 07/08/20,Last post 07/10/20
    Attempting to collect data, from multiple offices across the globe, to show how many locations a company has in various countries. Currently, there are 256 countries and roughly 5 "details" fields. We were hoping to be able to …
    Using Smartsheet113
    Jessica King
  • Paige Borchardt
    Answered - Pending Review Paige Borchardt 23 views 2 comments Most recent by Andrée Starå
    First post 07/06/20,Last post 07/10/20
    Hello, I was hoping there would be a way to add dividers in my dashboard. Sharing the dashboard with our ELT, it could be easier to separate categories with line dividers that take up 1 square. Thank you, Paige
    Using Smartsheet232
    Paige Borchardt
  • 24
    Answered - Pending Review 24 9 views 1 comment Most recent by Stefan
    First post 07/09/20,Last post 07/10/20
    I need help creating (2) condition in conditional formatting or a formulas that turns do the following; highlight all rows that are are between 3 and 5 days in the future from today's date highlight all rows that are more than 5 days in th…
    Using Smartsheet91
    24
  • Christopher Loh
    Answered - Pending Review Christopher Loh 8 views 1 comment Most recent by Andrée Starå
    First post 07/09/20,Last post 07/10/20
    I have a selection dropdown for a Contact List in a form. Is there a way to automatically update that dropdown contact list rather than manually adding and removing people as they leave or join my organization? I want to try to update con…
    Using Smartsheet81
    Christopher Loh
  • Niyati Kumar
    First post 07/10/20,Last post 07/10/20
    I see that this topic was open last year, but the thread was closed quoting a workaround--add the duration column to the report and have users modify it to get the desired end date. My project plans need dependencies enabled but I also ne…
    Using Smartsheet140
    Niyati Kumar
  • Tamara Diver
    Answered - Pending Review Tamara Diver 9 views 2 comments Most recent by Andrée Starå
    First post 07/10/20,Last post 07/10/20
    I'm trying to create Summary Reports but only ever receive the created date/name, modified date/name and sheet name columns to select from to add to the report. I've tried saving and going back in but no luck. The sheets I'm selecting all …
    Using Smartsheet92
    Tamara Diver
  • TeeM
    Answered - Pending Review TeeM 7 views 1 comment Most recent by Cierr
    First post 07/10/20,Last post 07/10/20
    I have 3 columns - Monthly Budget, Budget YTD and Total Spent YTD. I want any cells in the 'Total Spent YTD' column that are greater than the adjacent cells in the 'Budget YTD' column to highlight in a different colour. I don't seem to be …
    Using Smartsheet71
    TeeM
  • Riza
    Riza 309 views 3 comments Most recent by Marco Pellino
    First post 05/31/18,Last post 07/09/20
    Good day, May I ask if there is any way to create a Chart in Smartsheet without using a numeric data? I wanted to create a chart using names/phases as reference but I received an Invalid Data error message. It says, "To create a char…
    Using Smartsheet3093
    Riza
  • Jonathan Barfoot
    Answered - Pending Review Jonathan Barfoot 29 views 2 comments Most recent by Gretchen Hustad
    First post 02/21/20,Last post 07/09/20
    When choosing attachments in sheets it gives you the option for upload from computer, g-drive, and hyperlink. When using forms, the only option appears to be upload from computer. Is that the case or can a user select hyperlink or G-drive…
    Using Smartsheet292
    Jonathan Barfoot
  • Rob Hagan
    Rob Hagan 44 views 9 comments Most recent by Rob Hagan
    First post 06/13/20,Last post 07/09/20
    Hi, In recent times, my copy/pastes sometimes don't work. Most frustrating. One consistent workaround is to log off from SmartSheet and then log on again and then immediately do the failed copy/paste. It seems to be triggered by attemptin…
    Using Smartsheet449
    Rob Hagan
  • Brandon Mallette
    Accepted Answer Brandon Mallette 12 views 1 comment Most recent by RossL
    First post 07/09/20,Last post 07/09/20
    Hi there, Is there a way to create hyperlinks to go to a form that is already created? I am trying to create a central hub for all of my team requests to sit under, so we can send out one link and have all the different requests sitting th…
    Using Smartsheet121
    Brandon Mallette
  • Tanya Brooks
    Custom sortingQuestion
    Answered - Pending Review Tanya Brooks 9 views 1 comment Most recent by RossL
    First post 07/09/20,Last post 07/09/20
    HI - Anyone know if it is possible to create a custom sort in smartsheet? Example, in column “Title” I have the following values: ·      Assistant Professor ·      Associate Professor ·      Instructor ·      Professor If I sort by title a…
    Using Smartsheet91
    Tanya Brooks
  • Tim
    Tim 276 views 4 comments Most recent by Stacey Carrasco
    First post 02/22/18,Last post 07/09/20
    I was eager to checkout the recently released Smartsheet Charts, I have produced a couple of Pie Charts based on some real time data but seem to have found that limited funtionality/formatability (e.g. Not able to re-position labels) restr…
    Using Smartsheet2764
    Tim
  • Tristen Hannah
    Answered - Pending Review Tristen Hannah 18 views 2 comments Most recent by Tristen Hannah
    First post 07/07/20,Last post 07/09/20
    I am working on an approval process. It starts with the use of a form to take in the data, and then the process is kicked off. I have two separate workflows, one for the new row being added; and the next if the size of the class or start…
    Using Smartsheet182
    Tristen Hannah
  • coryg
    Answered - Pending Review coryg 66 views 12 comments Most recent by JReisman27
    First post 05/14/20,Last post 07/09/20
    Can anyone come up with a workaround for this situation: I have a submittal log for a construction project. I attach and log submittals in Smartsheet as they come in from the general contractor, and Smartsheet alerts the applicable design…
    Using Smartsheet6612
    coryg
  • Amy Gutirrez
    Accepted Answer Amy Gutirrez 9 views 3 comments Most recent by Andrée Starå
    First post 07/09/20,Last post 07/09/20
    Hi! Is there an option to automatically export to a google sheet? I know you can set up a recurring email w/ attachment, but was curious if there was similar capabilities via the export function. Thanks!
    Using Smartsheet93
    Amy Gutirrez
  • Julia C Peterson
    Answered - Pending Review Julia C Peterson 8 views 3 comments Most recent by Andrée Starå
    First post 07/09/20,Last post 07/09/20
    I created a tracker that I then created 20 copies of and each one is used by a different team. The sheets all have the same workflows/conditional formatting. The business owner keeps wanting to make tweaks to the sheet (like to add a colum…
    Using Smartsheet83
    Julia C Peterson
  • Prajna Jain
    Cell LinkingQuestion
    Answered - Pending Review Prajna Jain 18 views 13 comments Most recent by Paul Newcome
    First post 07/08/20,Last post 07/09/20
    I have a database and a sheet linked to it which is fetching few of the database columns. Whenever I sort data in the database the data in the other sheet (linked sheet) is not getting sorted. Any suggest how i can keep the data in the lin…
    Using Smartsheet1813
    Prajna Jain
  • Cierr
    Answered - Pending Review Cierr 13 views 2 comments Most recent by Cierr
    First post 07/09/20,Last post 07/09/20
    Hi To make data entry easier, I am using multi-select. When it comes to reporting this makes the process difficult because I want to create a pivot table to show where the items appear in each individual category. My example below will pr…
    Using Smartsheet132
    Cierr
  • Rob Hagan
    Answered - Pending Review Rob Hagan 22 views 2 comments Most recent by Susan B Peck
    First post 07/08/20,Last post 07/09/20
    Hi there, Not sure whether this is request for change or an error in our licensing/configuration, but the unlicensed users in our configuration see a message that reads "You have limited access to Smartsheet. Upgrade to use premium fe…
    Using Smartsheet222
    Rob Hagan
  • nkosikhona.msani89271
    Answered - Pending Review nkosikhona.msani89271 23 views 4 comments Most recent by nkosikhona.msani89271
    First post 06/23/20,Last post 07/09/20
    Hi There, I have developed a workflow with 5 Managers Approval request. I want to know if it possible for a manager to re-assign the approval request to another manager if they don't own the sheet? Kind Regards Nkosi
    Using Smartsheet234
    nkosikhona.msani89271
  • McKnight-MaryKate
    McKnight-MaryKate 62 views 3 comments Most recent by Genevieve P
    First post 09/14/18,Last post 07/09/20
    Is there any way for uploaded files on a Google form to be attached to the Smartsheet as regular attachments rather than in a column on the sheet with links to the Google Drive?
    Using Smartsheet623
    McKnight-MaryKate
  • Netanel yosef
    Netanel yosef 17 views 8 comments Most recent by Netanel yosef
    First post 07/07/20,Last post 07/09/20
    Hi, i have a sheet with my compeny task that update every day by project managers. each task get the data from the PMs ever the at 08:00 morning. i want to see all in Card view when the section is WW (work week) the problem is if i put all…
    Using Smartsheet178
    Netanel yosef
  • Preston
    Preston 32 views 4 comments Most recent by Genevieve P
    First post 01/02/19,Last post 07/09/20
    Occasionally, I am seeing reminder icons disappear from sheets. Seems to go away with a refresh. Anyone else? (Image)
    Using Smartsheet324
    Preston
  • Stevefc
    Answered - Pending Review Stevefc 1.1K views 34 comments Most recent by Genevieve P
    First post 08/15/19,Last post 07/09/20
    I am building a change control log. Is it possible to pre-populate a form with cell data from a sheet? For example, project name, ID, customer, description and resource from the sheet to help the process of logging a change to the change c…
    Using Smartsheet111034
    Stevefc