Welcome to the New Smartsheet Online Community
You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.
Recent Discussions
Find answers to Smartsheet questions, learn about project management best practices, discuss the future of work management, and get how-to guidance for every Smartsheet use-case from fellow users and Smartsheet experts.
Discussion List
-
Join us for our next FREE webinar- February 27!AnnouncementAnnouncement Stephanie Boulanger 24 views 0 comments 0 points Started by Stephanie Boulanger AnnouncementsFirst post 02/25/20,Last post 02/25/20Drive collaboration and transparency across your teams and organization, allowing everyone to work together to achieve more. In our upcoming webinar, you'll learn how Smartsheet streamlines collaboration through: Sharing sheets and workspa…Announcements240Stephanie Boulanger -
Welcome to the Smartsheet Online Community!AnnouncementAnnouncement Genevieve P 717 views 21 comments 1 point Most recent by Tim Meeks Welcome to the CommunityFirst post 12/11/19,Last post 02/11/20Welcome to the Smartsheet Online Community! Here in the Community, you can interact with other Smartsheet customers to get help and share best practices. All posts and comments are monitored by Smartsheet employees, our moderators, to e…Welcome to the Community71721Genevieve P -
We want to hear your Smartsheet story!AnnouncementAnnouncement Renee Coulombe 117 views 3 comments 2 points Most recent by Renee Coulombe AnnouncementsFirst post 02/06/20,Last post 02/06/20Has Smartsheet helped you change the way you work, achieve your goals, improve your team, grow your career — or just enable you to spend more time on the things that matter most? Share how you #CanDo by filling out this short form, attac…Announcements1173Renee Coulombe
-
Auto Fill Fields in SheetAnswered QuestionAnswered Jessica Langston 5 views 2 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 02/25/20,Last post 02/25/20Hello, I have 2 columns I am looking to auto populate based on what is selected in another column. Depending on the requestors name the Manager and Director will populate. The thing I am having trouble with is that multiple requestors ar…Formulas and Functions52Jessica Langston -
Using VALUE within an IF formula to covert text to numberAccepted AnswerAccepted Answer Tanya Boehmke 71 views 41 comments 0 points Most recent by Tanya Boehmke Formulas and FunctionsFirst post 01/24/20,Last post 02/25/20Hello, I've determined the issue with this formula is that the cell it is pulling from is formatted as text, not a number. I know I need to use the VALUE function to correct this, but I've tried this many different ways and cannot get it t…Formulas and Functions7141Tanya Boehmke
-
Integrations with HubspotAnswered QuestionAnswered Jerry Lenzo 6 views 2 comments 0 points Most recent by William Welch Premium Apps and IntegrationsFirst post 02/24/20,Last post 02/25/20Our Sales team is using Hubspot. I am looking for advice on integrating Hubspot with Smartsheet.Premium Apps and Integrations62Jerry Lenzo
-
Getting #unparseable using multiple IF functionAccepted AnswerAccepted Answer Nathan Nguyen 11 views 4 comments 0 points Most recent by Nathan Nguyen Formulas and FunctionsFirst post 02/25/20,Last post 02/25/20Hello Smartsheet community, I have been trying to resolve my error by looking online and this forum, but still can't fix my error. I'm hoping you smart experts can help me. I have 2 columns: Completion Status and Status. The Completion Sta…Formulas and Functions114Nathan Nguyen
-
Can I link sheets created in different accounts (memberships)?Unanswered QuestionFirst post 02/25/20,Last post 02/25/20Want a high level sheet for viewing defects across multiple vendors during UAT. Vendors have their own smartsheet accounts, and we have our own. Is this possible as long as I am a user on all the relevant smartsheets?Using Smartsheet40Janine Sheehan
-
Average FormulasAnswered QuestionAnswered Apolonio Fama 12 views 3 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 02/25/20,Last post 02/25/20Hi all, Need help with trying to get a formula for Averaging Transit Days for certain criterias in Carrier and Origin. Ultimately I'm trying to build a dashboard of transit days for each origin location. Below if formula I am trying, but…Formulas and Functions123Apolonio Fama
-
Contact List - Auto Populate ?Answered QuestionAnswered Anthony M DAmbrosio 13 views 2 comments 0 points Most recent by Paul Newcome Using SmartsheetFirst post 02/24/20,Last post 02/25/20Is there a way that Microsoft Office can automatically pull in our contact listing from Outlook into the Smartsheets Contact listing vs. having to manually type everyone in the organizations name? https://us.v-cdn.net/6031209/uploads/424…Using Smartsheet132Anthony M DAmbrosio
-
Average duration for a specific type and yearAnswered QuestionFirst post 02/24/20,Last post 02/25/20I'm trying to get a formula to work in the Sheet Summary for a sheet I have that collects data on updates I would like this formula to tell me the Average duration of a specific type of update for a specific year. The columns my formula …Formulas and Functions151Peggy P
-
First post 02/25/20,Last post 02/25/20I've created separate shipping sheets for individual projects that detail if and when items have shipped. In the separate shipping sheets, I have a symbols column titled "Item Shipped?" which offers a choice of "yes, hold, a…Using Smartsheet30Mark Silvester
-
New Help on If/AND to amortize contract revenueAnswered QuestionFirst post 02/25/20,Last post 02/25/20Below are my cells and formula which keeps returning INVALID: https://us.v-cdn.net/6031209/uploads/005/P93KDRXB6I0I.pngFormulas and Functions81Lisa Burgess
-
How do you write a SUMIFS forumula with 3 criteria?Answered QuestionAnswered Lisa Burgess 12 views 1 comment 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 02/25/20,Last post 02/25/20Below is my formula, but I am not getting it right: =SUMIFS({2020 OE Revenue Actual & Projected Range 1}, {2020 OE Revenue Actual & Projected Range 2}, "New Business", [({2020 OE Revenue Actual & Projected Range 3}, …Formulas and Functions121Lisa Burgess
-
Date chaging to start of the week formulaAnswered QuestionAnswered Lubica Zummerova 10 views 1 comment 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 02/25/20,Last post 02/25/20Hi all, I was wondering if there is a formula that can take my start date that occurs at any random day of the week in column A (lets say tasks starts on a Tuesday 25/02/2020) and give me a date of the start of the week in column B (Mon…Formulas and Functions101Lubica Zummerova
-
First post 10/03/18,Last post 02/25/20I have a sheet with a lot of docs uploaded, tried to load another yesterday and couldn't. I'm guessing there are # and/or size limitations for files for sheets, but I can't find that info anywhere - and even if I knew the limitations, I'm …Using Smartsheet8211frobison14816
-
Parent/Child Hierarchy when Building ReportsAnswered QuestionFirst post 02/25/20,Last post 02/25/20Hi - I'm trying to build a report for "Upcoming Tasks" in the next 7 days. I would like to show parent and child hierarchy in the report. However, I am not able to figure out the logic in the report builder? Any help will be appr…Using Smartsheet173Susanthi Kodali
-
Count open RAID items based off of dropdown menuAnswered QuestionFirst post 02/25/20,Last post 02/25/20I'm trying to get a count of open RAID items. We have the following statuses in the status dropdown: New, In Progress, Backlog, Requires Validation, and Complete. What is wrong with this formula?: =COUNTIFS([Type (RAAIDD)]:[Type (RAAIDD)…Formulas and Functions73Allison H
-
RYG Formula Based on CheckboxAccepted AnswerAccepted Answer Ray B 9 views 5 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 02/25/20,Last post 02/25/20Smartsheet Community: I need a little help with this Formula: =IF([email protected] = 1, "Green", IF([email protected] <> 1 "Grey", "Red") I would like to have the row turn Grey if None of the Children Checkbox are Chec…Formulas and Functions95Ray B
-
Accepted Answer Shirley Bittner 9 views 2 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 02/25/20,Last post 02/25/20When I use an automation workflow from a form question hidden as I have the formula as the default value of that question, how can I get it to work it's formula instead of it overriding as a text? So when I put in the formula in the defaul…Formulas and Functions92Shirley Bittner
-
First post 11/04/19,Last post 02/25/20how i can to do an automatic different color per row ? see example from excel: (Image)Using Smartsheet854Netanel yosef
-
First post 11/07/19,Last post 02/25/20Hello, is it possible to export only the filtered rows to excel? When doing the export, it will hide the rows that were filtered, but they will still be in the excel so if I try to copy and paste or create a mailmerge, the excel will also …Using Smartsheet524NSAN
-
How to add column that shows start/finish time in minutes?Answered QuestionAnswered Daniel William Maycock 16 views 2 comments 0 points Most recent by Daniel William Maycock Using SmartsheetFirst post 02/24/20,Last post 02/25/20I see you can list a task in minute increments, e.g. 15min. We are creating a cutover plan and need to list a start & finish TIME: e.g. 9:00, 10:00, etc. Does Smartsheet have this as an "intelligent" column or just a text/n…Using Smartsheet162Daniel William Maycock
-
Use form to send email to take actionAccepted AnswerFirst post 02/20/20,Last post 02/25/20Hello, I have a workflow where I am trying to add a email note as a form and asking them to review attached document, take action. For some reason, the automation that I added, does not send the email verbiage I added. What am I doing wron…Using Smartsheet223SamiV
-
Is there a sheet map overview?Answered QuestionFirst post 02/25/20,Last post 02/25/20Is there a way to see the sheets we have and what they are connected to? I am thinking something along the lines of a master sheet showing links in and out to the sheets listed from a wide open perspective. I do not need to know the spec…Using Smartsheet63Timothy French
-
Custom gantt chart zoom for timelineAnswered QuestionFirst post 02/25/20,Last post 02/25/20Hello, From what I have seen it's not possible, but I can't understand why, is there a way to have the gantt chart timeline displayed only for the period of the project (beginning the first month of the project and ending the last month fo…Using Smartsheet112Antoine Retaggi
-
A few questions..Unanswered QuestionFirst post 02/25/20,Last post 02/25/20When in Dynamic View and data is entered through a form, the filters I had set up get greyed out and disappear (i.e. I am filtering by JOB# and JOB NAME). This is not the case in my normal sheet however. The same data from the form entry i…Using Smartsheet50Sidonia Posteuca
-
First post 01/07/20,Last post 02/25/20It would help so much if there was a workflow that could send out the link to a form on a custom (daily, weekly, etc.) basis. Right now I have to create a row that triggers the form to be sent weekly and just put the link to the form in th…Using Smartsheet432Jacqueline Waller
-
First post 08/20/19,Last post 02/25/20I'm new to smartsheet and trialing it at the moment. I have a question, I hope you can help me with: I have a portfolio of companies in a main sheet and their debt issues, and related stuff in several sheets. Rows are companies/debt issue…Formulas and Functions40910dlnvtl
-
Update cells via form or secondary sheet?Accepted AnswerAccepted Answer Xander Brennan 22 views 11 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 02/19/20,Last post 02/25/20I have a sheet of contracts with 30 columns (status/progression/etc). The columns are updated by different people in different departments. Is there anyway to create a form that would have a dropdown of the contract ID and then the cells I…Formulas and Functions2211Xander Brennan -
Multiple approval workflowsAnswered QuestionAnswered Leslie Sutula (US - IFS) 23 views 3 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 02/18/20,Last post 02/25/20Hi - I am trying to create 3 approval workflows. Each one as a sequence of approvers and some of those approvers are the same from workflow to workflow but for different approval purposes. I have been successful in setting up the first o…Using Smartsheet233Leslie Sutula (US - IFS)
-
Is it possible to use a formula to help users complete a form?Answered QuestionFirst post 01/16/20,Last post 02/25/20We are asking for updates to quality documents. The form asks for the document number and the title. Is there way to auto-populate the title in the Form once the number is entered?Formulas and Functions323Pam Grant -
Edit SubmissionsAnswered QuestionFirst post 02/10/20,Last post 02/25/20Is it possible for a user to retrieve a pre-filled form with their old submission if they want to change something?Using Smartsheet165Jeff McFarland
