Sheets

Discussion List

• 
  VLOOKUP to another sheet using images

  caroline_allen37286 166 views 11 comments 0 points Most recent by Meagan Harte 05/27/20Formulas and Functions
  First post 02/12/18,Last post 05/27/20
  I love the new VLOOKUP functionality and am using it to try to reference IMAGES that I have stored in another sheet.However, I noticed that SmartSheet only pulls in the image name (example: imagename.jpg) and does not actually show the ima…
  Formulas and Functions16611
  caroline_allen37286
• 
  Mirroring a Grandchild row cell in the Child row cell based off current weekQuestion

  Answered - Pending Review A. Marcus 16 views 4 comments 0 points Most recent by A. Marcus 05/27/20Formulas and Functions
  First post 05/21/20,Last post 05/27/20
  Hey all, I'm relatively new to Smartsheets and am hoping someone can help me out. I promise I've looked everywhere for an answer and I think I'm making this more complicated than it is. Thanks in advance for the guidance! I have a sheet …
  Formulas and Functions164
  A. Marcus
• 
  Default Background Color

  Ty Layton 18 views 4 comments 0 points Most recent by Ty Layton 05/27/20Using Smartsheet
  First post 05/22/20,Last post 05/27/20
  Greetings I some how got the background of one of my smartsheets to appear gray whenever I create a new column and when I pull a report and display the Sheet Name (system column) it too appears to be gray. I have doubled checked the condi…
  Using Smartsheet184
  Ty Layton
• 
  Updating a Date Column after another cell is updated.Accepted Answer

  Accepted Answer Eric Glassey 9 views 3 comments 0 points Most recent by Andrée Starå 05/27/20Formulas and Functions
  First post 05/27/20,Last post 05/27/20
  I am trying to have a Date Column update with today's date when a single select option is chosen. I don't want to use the system update date column because that will get updated whenever any cell is selected. For example: I have a single …
  Formulas and Functions93
  Eric Glassey
• 
  Use Wildcards in an INDEX MATCH formulaQuestion

  Answered - Pending Review Jose Rivera 21 views 1 comment 0 points Most recent by [email protected] 05/27/20Formulas and Functions
  First post 05/25/20,Last post 05/27/20
  Hi everyone, I need to use INDEX MATCH formula to get a DS# with a CNDT# in another report. The easy formula would be: =INDEX({DS Report Range 2}, MATCH([CNDT Number]1, {DS Report Range 3}, 0)), "") but the thing is that sometim…
  Formulas and Functions211
  Jose Rivera
• 
  How can I count dates in the past/future?Question

  Answered - Pending Review Carolina Rivera 9 views 2 comments 0 points Most recent by Carolina Rivera 05/27/20Formulas and Functions
  First post 05/27/20,Last post 05/27/20
  Hi, I'm trying to create a formula that counts certain actions in a column based on their date. Say, if there are three dates: 5/15/2020, 5/20/2020, and 5/30/2020, I want to be able to know which ones are in the future and which ones are …
  Formulas and Functions92
  Carolina Rivera
• 
  Left Horizontal Scroll with Mouse

  Carly Sorensen 209 views 4 comments 1 point Most recent by Shane Cyr 05/27/20Using Smartsheet
  First post 06/21/18,Last post 05/27/20
  Any time I try to scroll left on a sheet, it takes me back to the previous page. So, if I am in a sheet and cannot see the left most columns, I have to select a random cell and hit the left arrow key until I can see the left columns. Rig…
  Using Smartsheet2094
  Carly Sorensen
• 
  Proofing - Office Documents

  Michael Lockwood 112 views 8 comments 0 points Most recent by Andrée Starå 05/27/20Using Smartsheet
  First post 10/14/19,Last post 05/27/20
  Is there a plan to include Office documents such as Word Docs or PowerPoints into the functionality of proofing without having to convert them to PDF for uploading them?
  Using Smartsheet1128
  Michael Lockwood
• 
  How do I auto-save a sheet without opening the sheet?Question

  Answered - Pending Review Lawrence West 31 views 13 comments 0 points Most recent by Paul Newcome 05/27/20Using Smartsheet
  First post 05/19/20,Last post 05/27/20
  I use conditional formatting. When I review the dashboard, the formatting doesn't update until I go to the sheet and save. I would like the sheet to save automatically when conditional formatting makes changes. Thank You.
  Using Smartsheet3113
  Lawrence West
• 
  How can I count the amount of actions in one specific month?Accepted Answer

  Accepted Answer Carolina Rivera 12 views 3 comments 0 points Most recent by Paul Newcome 05/27/20Formulas and Functions
  First post 05/27/20,Last post 05/27/20
  Hi, I'm trying to set up a counter for a number of actions in the month of may, for example if I have 5 actions this month (May), I want the counter to return "5". I've been trying to use the formula below but all I get in return…
  Formulas and Functions123
  Carolina Rivera
• 
  Counting amount of actions in one monthQuestion

  Answered - Pending Review Carolina Rivera 13 views 1 comment 0 points Most recent by Paul Newcome 05/27/20Formulas and Functions
  First post 05/26/20,Last post 05/27/20
  Hi, I'm trying to set up a counter for a number of actions in the month of may, for example if I have 5 actions this month, I want the counter to return "5". I've been trying to use the formula below but all I get in return is a…
  Formulas and Functions131
  Carolina Rivera
• 
  Any templates or sample of multiple project dashboards?

  Fairorth 319 views 9 comments 0 points Most recent by Andrée Starå 05/27/20Using Smartsheet
  First post 12/06/19,Last post 05/27/20
  Our small company does several projects at a time and all of them basically follow the same project plan. We created a nice template that contains the dozen or so tasks in our project. Most of the reports and dashboards I've tried to crea…
  Using Smartsheet3199
  Fairorth
• 
  How can I add a number of days to a date column in the same sheet?Accepted Answer

  Accepted Answer Carolina Rivera 14 views 4 comments 0 points Most recent by Andrée Starå 05/27/20Formulas and Functions
  First post 05/22/20,Last post 05/27/20
  Hi! I currently have a column that is supposed to add 14 days to another date column in the same sheet. The formula I'm using is: =["Date Column"] + 14 However, what I keep getting is "Apr 21, 2020 3:10 PM14". Both co…
  Formulas and Functions144
  Carolina Rivera
• 
  One person has multiple jobs on one dayQuestion

  Question Ben Cutler 16 views 0 comments 0 points Started by Ben Cutler 05/26/20 Using Smartsheet
  First post 05/26/20,Last post 05/26/20
  Hi, I'm looking to adjust my sheet based on one person having multiple jobs in one day. What I'd like to do it have it be that each person has only one job per day. Ideally, SS would be able to look at all other jobs this person is assigne…
  Using Smartsheet160
  Ben Cutler
• 
  User Unsubscribed from Automated WorkflowQuestion

  Answered - Pending Review Matt Hanberry 13 views 1 comment 0 points Most recent by Paul Newcome 05/26/20Using Smartsheet
  First post 05/26/20,Last post 05/26/20
  Hi I have set up automation on a sheet to email spacific people when lines are added, some of them have complained they are not recieving the emails and when i looked into the Activity Log it shows User Unsubscribed from Automated Workflow…
  Using Smartsheet131
  Matt Hanberry
• 
  Display Logo at the sheet levelAccepted Answer

  Accepted Answer rcabral 12 views 6 comments 0 points Most recent by rcabral 05/26/20Using Smartsheet
  First post 05/26/20,Last post 05/26/20
  Hi, is there a possibility to display 2 logos at the sheet level? I know that I can include a logo image to the workspace and that will replace the "smartsheet" logo from all files within that workspace. But what I am trying to d…
  Using Smartsheet126
  rcabral
• 
  Auto Generated Number ReferencingQuestion

  Answered - Pending Review Amanda Berta 19 views 3 comments 0 points Most recent by Andrée Starå 05/26/20Using Smartsheet
  First post 05/22/20,Last post 05/26/20
  Hi, I noticed when using Index match on auto generated numbers something weird happens. On sheet A I use Index({desired result Sheet B}, match(sheet A @row, {search Criteria Sheet B},0),1) where Sheet A @Row is an auto generated number an…
  Using Smartsheet193
  Amanda Berta
• 
  Form from one sheet populates another sheetAccepted Answer

  Accepted Answer Paul Grim 95 views 31 comments 0 points Most recent by Paul Grim 05/26/20Using Smartsheet
  First post 04/17/20,Last post 05/26/20
  Hello SS gurus, I am relatively new to SS "in the field", although I've watched over 20 hours of videos from the SS Learning Center so I have a good understanding of the mechanics. Here is what I'm trying to do... We need to t…
  Using Smartsheet9531
  Paul Grim
• 
  Can I populate Smartsheet rows from a SQL Database read?Question

  Answered - Pending Review Senthil Anandarangan 18 views 3 comments 0 points Most recent by Sean Morgan 05/26/20API & Developers
  First post 05/22/20,Last post 05/26/20
  I have data on Snowflake data warehouse and also on a SQL server table. Does Smartsheet support connection to Snowflake or SQL database to read data and populate rows on a Smartsheet?
  API & Developers183
  Senthil Anandarangan
• 
  Lock or Store Date/Value Solution without using Zapier

  Andrée Starå 25 views 0 comments 0 points Started by Andrée Starå 05/24/20 Formulas and Functions
  First post 05/24/20,Last post 05/24/20
  Hi all, I hope you're well and safe! I've developed a solution that lets you store the date or value. You'd use the copy-row automation and a VLOOKUP or combination of INDEX/MATCH to make it work. We'd trigger the copy-row to another sh…
  Formulas and Functions250
  Andrée Starå
• 
  VLOOKUP with Duplicate DataQuestion

  Answered - Pending Review Kevin Segrist 59 views 4 comments 0 points Most recent by Andrée Starå 05/22/20Formulas and Functions
  First post 05/19/20,Last post 05/22/20
  I have a master sheet that may have duplicated column data, like: Client Name | Status (dropdown) | Delivery Date | Feature (checkbox) Client A …
  Formulas and Functions594
  Kevin Segrist
• 
  Work Flow - Clone to another worksheet

  beth_linder28141 285 views 8 comments 0 points Most recent by Lillian Fenner 05/22/20Using Smartsheet
  First post 05/21/19,Last post 05/22/20
  I LOVE the work flows!!! But I have 15 facilities and 15 of the same worksheets. Is it possible to: 1. Clone the work flow from one worksheet to another or 2. print the work flow so i can enter the same verbiage & flow in all the sh…
  Using Smartsheet2858
  beth_linder28141
• 
  Is there a way to alphabetically sort collaborators and shared users (when emailing a sheet)?Question

  Answered - Pending Review Peggy Finley 9 views 1 comment 0 points Most recent by Andrée Starå 05/22/20Using Smartsheet
  First post 05/22/20,Last post 05/22/20
  I have sheets that I want to notify a few people of changes. When I use the email to shared users function it will list all users shared to the workspace first and also users shared to the sheet. It would be helpful to see the list in na…
  Using Smartsheet91
  Peggy Finley
• 
  Get a list value from another sheet

  Jonathan Vo 478 views 11 comments 1 point Most recent by Andrée Starå 05/22/20Formulas and Functions
  First post 04/22/18,Last post 05/22/20
  Hi All, I have a sheet of drivers list. And in another sheet, I want to create a column which get driver name from drivers sheet. Can I do it in smartsheet? Thanks
  Formulas and Functions47811
  Jonathan Vo
• 
  Link Reference Sheet Dropdown

  Rachel H 2K views 17 comments 1 point Most recent by Victor Galier 05/21/20Formulas and Functions
  First post 04/01/18,Last post 05/21/20
  Is it possible to reference a list on a separate sheet for the user to select as they input data into rows?For example; activity type, client name? I have created a time sheet and would like users to reference the data in another sheet. …
  Formulas and Functions199917
  Rachel H
• 
  When saving as new, I want to break links including sumifs but I'm having an issueQuestion

  Answered - Pending Review Jennifer Murphy 10 views 1 comment 0 points Most recent by Paul Newcome 05/21/20Using Smartsheet
  First post 05/21/20,Last post 05/21/20
  I have a sheet that's linked into a pivot sheet via a series of sumif cross sheet formulae. This sheet is looking into the pivot sheet at a point in time e.g. month of April YTD information, and the Pivot will update monthly as new data i…
  Using Smartsheet101
  Jennifer Murphy
• 
  Chart budget vs actualQuestion

  Answered - Pending Review Laura Corredor 57 views 5 comments 0 points Most recent by Laura Corredor 05/21/20Using Smartsheet
  First post 03/25/20,Last post 05/21/20
  Hello, I have a sheet where I can see budget, actual and variance for my project budget. So column 1 is january budget, column 2 january actual and column 3 january variance, and so on. All I want to is to create a line-type chart for my d…
  Using Smartsheet575
  Laura Corredor
• 
  Is There any option to make custom form using own html,or any functionality to achieve attached formQuestion

  Answered - Pending Review Bryant LeBlanc 37 views 3 comments 0 points Most recent by Andrée Starå 05/21/20Using Smartsheet
  First post 05/18/20,Last post 05/21/20
  https://us.v-cdn.net/6031209/uploads/750/WYLMD58BR7UY.png
  Using Smartsheet373
  Bryant LeBlanc
• 
  Datamesh from a summary reportQuestion

  Answered - Pending Review Jennifer.Stangret 42 views 7 comments 0 points Most recent by Sheryl P 05/21/20Premium Apps and Integrations
  First post 01/27/20,Last post 05/21/20
  hi! I am trying to build a means to automatically forecast vendor costs, based on a count. I have a large sheet that contains an intersection of many Locations and the Scopes that will be applied to each location. I have different vendo…
  Premium Apps and Integrations427
  Jennifer.Stangret
• 
  Can I combine multiple rows into one row on a Gantt Chart?Accepted Answer

  Accepted Answer Sam Ng 22 views 3 comments 0 points Most recent by Andrée Starå 05/20/20Using Smartsheet
  First post 05/19/20,Last post 05/20/20
  Dear all, I want to aggregate multiple project schedules into a master schedule. When copying the milestones from various projects into a single sheet, my overall Gantt Chart displays an event as a row, and each project occupies many rows.…
  Using Smartsheet223
  Sam Ng