community.smartsheet.com Open in urlscan Pro
2606:4700:7::a29f:8a4e  Public Scan

Form analysis
0 forms found in the DOM

Text Content

YOUR PRIVACY

Welcome to Smartsheet! We’re glad you’re here and want you to know that we
respect your privacy and your right to control how we collect, use, and share
your personal data. Please read our Privacy Notice to learn about our privacy
practices. Manage my preferences
Powered by
Reject AllAccept All
___

Skip to content

 * Discussions
 * Topics
 * Support
 * Product Ideas
 * Help & Learning




Sign in
Try Smartsheet



EXPLORE. ASK. ANSWER.



Find peer-to-peer information about everything Smartsheet related – from project
management best practices to invaluable how-to guidance from fellow users and
Smartsheet experts.

Clear

SearchLoading




UNLOCK YOUR POTENTIAL AT ENGAGE IN LONDON

SAVE YOUR SPOT AT OUR INAUGURAL EVENT IN THE UK WHILE EARLY BIRD PRICING IS
STILL LIVE.

Register now


AREAS TO EXPLORE

About the Smartsheet Community
Get a quick tour and check out all the benefits of logging in.

Browse discussions
See what’s been recently shared and join those conversations that interest you.

Earn Badges + Swag
Let’s celebrate! Join now and start earning points, badges, and Smartsheet swag.

Share your ideas
Tell us about the product improvements you want to see and vote on existing
ideas.

Get Help with Smartsheet
Find answers to your Smartsheet questions in English, Deutsch, 日本語, and Español.

Show & Tell
Share and celebrate - whether a promotion, a new Smartsheet solution, best
practice or badge. Share the good news and cheer on others!

AnnouncementsRecent DiscussionsNewest Questions


 * NOMINATE PEAK HUMANS & GET A BADGE!
   
   Hi Smartsheet Community, We loved learning about what operating at your peak
   looks like for you, and now, we want to give you the opportunity to recognize
   and celebrate others, and earn cool badges as…
   
   Announcement
   badges
   peakhuman
   Show & Tell
   2469
   Feb 24, 2024
   93
   


 * FEBRUARY QUESTION OF THE MONTH - JOIN THE CONVERSATION AND RECEIVE A BADGE
   
   The Smartsheet Community aims for the stars, and we love that about you! The
   responses to January's question were fantastic - You want to get certified,
   and be more present, but also do 365 kickflips,…
   
   Announcement
   QofMonth
   Show & Tell
   1747
   Feb 24, 2024
   141
   


 * MEET DEBBIE SAWYER, OUR FEBRUARY MEMBER SPOTLIGHT! 🎉
   
   Put your hands in the air like you just don’t care and get to know @Debbie
   Sawyer, our February Member Spotlight! In addition to being a newly inducted
   Community Champion (🎉), Debbie is the Chief Sma…
   
   Announcement
   Member Spotlight
   Member Spotlight
   162
   Feb 21, 2024
   3
   


 * NEW AND IMPROVED SAFE SHARING EXPERIENCE, NOW GENERALLY AVAILABLE!
   
   Hi Community, For those of you who are SysAdmins who used Safe Sharing in the
   past, you may have found the old experience to be a bit basic and hard to
   manage or audit. That’s why we’re excited to ann…
   
   Announcement
   Product Announcements
   518
   Feb 21, 2024
   14
   


 * INCREASED PLAN INSIGHTS DISCOVERABILITY ON ADMIN CENTER, NOW GENERALLY
   AVAILABLE
   
   Hi Community, Many SysAdmins have told us that they are unsure about the
   difference between the Unlicensed User count on the Admin Center home page
   and the Internal Collaborator count in Plan Insights…
   
   Announcement
   Product Announcements
   112
   Feb 20, 2024
   1
   


 * LARGE/INDEX TO RETURN VALUE ONCE ONLY
   
   Please find example of the issue that I am experiencing in a Smartsheet
   column. As you can see in the screenshot, there are duplicate values in 9 &
   11, then 12, 13 & 14. However, I wish to only popula…
   
   Answered
   Formulas and Functions
   65
   8:42 am
   2
   


 * AUTOMATICALLY POPULATING A CELL
   
   Hi everyone. Some help please. I've been through index match but I don't
   think it's what I want. What I want to do is... Someone submits a form with
   one of the fields being "sub job", selected from a …
   
   Answered ✓
   Formulas and Functions
   46
   7:52 am
   2
   


 * SAVE A REPORT ON A MONTHLY BASIS
   
   Hi I have a Smartsheet report that I need to save a snapshot of on a monthly
   basis (1st of each month). Ideally I'd like this automated so that it is
   downloaded as an excel spreadsheet each month. Cur…
   
   Answered
   Reports
   Automations
   Smartsheet Basics
   18
   6:50 am
   2
   


 * CAN SMARTSHEET INTEGRATION UPDATE THE HARVEST FORECAST?
   
   Good afternoon I'm hoping someone can assist me with some advice please? I
   have a client using Smartsheet for projects and Harvest for Time management.
   If we connect Smartsheet with Harvest, would the…
   
   Answered
   Integrations
   API & Developers
   499
   4:46 am
   3
   


 * NETWORKDAYS RETURNING 2 WHEN START AND END DATE ARE THE SAME
   
   Hi team, I've come across an odd ball that I've never seen before with the
   Networkdays formula. The formula I started with was:
   =IFERROR(NETWORKDAYS(DATEONLY([Created Date]@row), [Date Closed]@row), "…
   
   Answered
   Smartsheet Basics
   28
   4:46 am
   3
   


 * SAVE A REPORT ON A MONTHLY BASIS
   
   Hi I have a Smartsheet report that I need to save a snapshot of on a monthly
   basis (1st of each month). Ideally I'd like this automated so that it is
   downloaded as an excel spreadsheet each month. Cur…
   
   Answered
   Reports
   Automations
   Smartsheet Basics
   18
   6:50 am
   2
   


 * FORM LINK FIELD VALIDATION
   
   Hello, Is there a way to add validation to a hyperlink field on a FORM? I
   could run a check after submittal, but that is more effort than it is worth.
   Double Dipping here: I was reading an article on …
   
   Question
   Forms
   hyperlink
   Smartsheet Basics
   17
   3:27 am
   


 * NETWORKDAYS RETURNING 2 WHEN START AND END DATE ARE THE SAME
   
   Hi team, I've come across an odd ball that I've never seen before with the
   Networkdays formula. The formula I started with was:
   =IFERROR(NETWORKDAYS(DATEONLY([Created Date]@row), [Date Closed]@row), "…
   
   Answered
   Smartsheet Basics
   28
   4:46 am
   3
   


 * NUMBER OF MONTHS 2 DATES SPAN
   
   Hi - I'm trying to figure out a formula to determine the number of months 2
   dates span. NOT the number of months between two dates. For example, row 19
   is 3 (Dec, Jan, Feb), Row 20 is 1 and Row 28 is …
   
   Answered
   Formulas and Functions
   29
   4:06 am
   2
   


 * HOW TO RETURN "0" IN A CELL WHEN ANOTHER CELL HAS BEEN FLAGGED
   
   I created a timesheet and a form to go along with it. When someone uses the
   form and flags that someone has called off, I want the flag to return zeros
   in the ST Hrs, OT Hrs, and DT Hrs cells. Using A…
   
   Answered ✓
   Formulas and Functions
   39
   Feb 25, 2024
   3
   


EXPLORE. ASK. ANSWER.

Find peer-to-peer information about everything Smartsheet related – from project
management best practices to invaluable how-to guidance from fellow users and
Smartsheet experts.
 
«1234567…100»


DISCUSSION LIST


 * NOMINATE PEAK HUMANS & GET A BADGE!
   
   Hi Smartsheet Community, We loved learning about what operating at your peak
   looks like for you, and now, we want to give you the opportunity to recognize
   and celebrate others, and earn cool badges as…
   
   Announcement
   badges
   peakhuman
   Show & Tell
   2469
   Feb 24, 2024
   93
   


 * FEBRUARY QUESTION OF THE MONTH - JOIN THE CONVERSATION AND RECEIVE A BADGE
   
   The Smartsheet Community aims for the stars, and we love that about you! The
   responses to January's question were fantastic - You want to get certified,
   and be more present, but also do 365 kickflips,…
   
   Announcement
   QofMonth
   Show & Tell
   1747
   Feb 24, 2024
   141
   


 * MEET DEBBIE SAWYER, OUR FEBRUARY MEMBER SPOTLIGHT! 🎉
   
   Put your hands in the air like you just don’t care and get to know @Debbie
   Sawyer, our February Member Spotlight! In addition to being a newly inducted
   Community Champion (🎉), Debbie is the Chief Sma…
   
   Announcement
   Member Spotlight
   Member Spotlight
   162
   Feb 21, 2024
   3
   


 * NEW AND IMPROVED SAFE SHARING EXPERIENCE, NOW GENERALLY AVAILABLE!
   
   Hi Community, For those of you who are SysAdmins who used Safe Sharing in the
   past, you may have found the old experience to be a bit basic and hard to
   manage or audit. That’s why we’re excited to ann…
   
   Announcement
   Product Announcements
   518
   Feb 21, 2024
   14
   


 * INCREASED PLAN INSIGHTS DISCOVERABILITY ON ADMIN CENTER, NOW GENERALLY
   AVAILABLE
   
   Hi Community, Many SysAdmins have told us that they are unsure about the
   difference between the Unlicensed User count on the Admin Center home page
   and the Internal Collaborator count in Plan Insights…
   
   Announcement
   Product Announcements
   112
   Feb 20, 2024
   1
   


 * THE SMARTSHEET COMMUNITY GOES GLOBAL! SPANISH, GERMAN, AND JAPANESE TOPICS
   NOW AVAILABLE
   
   We're thrilled to announce the launch of Global Discussions in the Smartsheet
   Community! At Smartsheet, we believe language shouldn't be a barrier to
   collaboration and understanding. That's why we're …
   
   Announcement
   Global Discussions
   General Announcements
   496
   Feb 19, 2024
   4
   


 * NEW REACTIVATION POLICY FOR DEACTIVATED USERS
   
   Hi Community, As you may already know, Smartsheet allows customers to
   deactivate users that have left their organization as a strong security and
   cost management measure, thereby enabling the realloca…
   
   Announcement
   Product Announcements
   296
   Feb 16, 2024
   5
   


 * HELP ARTICLE UPDATES
   
   Hello Community, We’ve added new collections of articles, called learning
   tracks, to help you dig deeper into some areas of Smartsheet. Read on to
   learn more about some of the content that is now avai…
   
   Announcement
   WorkApps
   Dynamic View
   help
   General Announcements
   111
   Feb 16, 2024
   1
   


 * SMARTSHEET FORWARD Q1 2024: MAKING WORK SMOOTHER, MORE INTUITIVE, AND FUN
   
   As we kick off 2024, many of you have been reflecting on your goals for the
   new year, and at Smartsheet we’ve been actively working on a whole bunch of
   new capabilities to help you reach your goals at…
   
   Announcement
   Product Development
   announcement
   Smartsheet Forward
   Product Announcements
   250
   Feb 13, 2024
   


 * NEW AND IMPROVED USER INVITATION EMAIL NOW GENERALLY AVAILABLE!
   
   Hi Community, You now have access to the new and improved user invitation
   emails that new users receive when they are invited to join a Smartsheet
   plan! Additionally, we updated the interstitial scree…
   
   Announcement
   Product Announcements
   364
   Feb 9, 2024
   4
   


 * LARGE/INDEX TO RETURN VALUE ONCE ONLY
   
   Please find example of the issue that I am experiencing in a Smartsheet
   column. As you can see in the screenshot, there are duplicate values in 9 &
   11, then 12, 13 & 14. However, I wish to only popula…
   
   Answered
   Formulas and Functions
   65
   8:42 am
   2
   


 * AUTOMATICALLY POPULATING A CELL
   
   Hi everyone. Some help please. I've been through index match but I don't
   think it's what I want. What I want to do is... Someone submits a form with
   one of the fields being "sub job", selected from a …
   
   Answered ✓
   Formulas and Functions
   46
   7:52 am
   2
   


 * SAVE A REPORT ON A MONTHLY BASIS
   
   Hi I have a Smartsheet report that I need to save a snapshot of on a monthly
   basis (1st of each month). Ideally I'd like this automated so that it is
   downloaded as an excel spreadsheet each month. Cur…
   
   Answered
   Reports
   Automations
   Smartsheet Basics
   18
   6:50 am
   2
   


 * CAN SMARTSHEET INTEGRATION UPDATE THE HARVEST FORECAST?
   
   Good afternoon I'm hoping someone can assist me with some advice please? I
   have a client using Smartsheet for projects and Harvest for Time management.
   If we connect Smartsheet with Harvest, would the…
   
   Answered
   Integrations
   API & Developers
   499
   4:46 am
   3
   


 * NETWORKDAYS RETURNING 2 WHEN START AND END DATE ARE THE SAME
   
   Hi team, I've come across an odd ball that I've never seen before with the
   Networkdays formula. The formula I started with was:
   =IFERROR(NETWORKDAYS(DATEONLY([Created Date]@row), [Date Closed]@row), "…
   
   Answered
   Smartsheet Basics
   28
   4:46 am
   3
   


 * NUMBER OF MONTHS 2 DATES SPAN
   
   Hi - I'm trying to figure out a formula to determine the number of months 2
   dates span. NOT the number of months between two dates. For example, row 19
   is 3 (Dec, Jan, Feb), Row 20 is 1 and Row 28 is …
   
   Answered
   Formulas and Functions
   29
   4:06 am
   2
   


 * FORM LINK FIELD VALIDATION
   
   Hello, Is there a way to add validation to a hyperlink field on a FORM? I
   could run a check after submittal, but that is more effort than it is worth.
   Double Dipping here: I was reading an article on …
   
   Question
   Forms
   hyperlink
   Smartsheet Basics
   17
   3:27 am
   


 * IS THERE A RULE TO CHANGE PRIORITY IN A COLUMN, WHEN DUE DATE IN ANOTHER
   COLUMN IS WITHIN 30 DAYS
   
   I have a sheet set up with a list of tasks One column is dedicated for
   "Priority" *High, Medium, Low" Importance. Once column has due dates, for
   each of the line item tasks Is there a rule or formula …
   
   Answered
   Formulas and Functions
   40
   3:04 am
   3
   


 * REPORT SUMMARY AND GROUPING: ADD CUSTOM FORMATTING
   
   A few things that would improve Report Summary and Grouping: Ability to
   format the summary data (IE into $ format) Grouping by contact column Pull
   summary data as a metric into a Dashboard Thanks!
   
   Reports
   Idea Submitted
   Smartsheet Product Feedback & Ideas
   1107
   2:32 am
   16
   


 * QUESTIONS ON DATAMESH
   
   Dear All: Good morning. We are VERY close to getting the approval from my top
   management for DataMesh - this is something I have been hoping to get for us
   since 2019. We were able to help 4 department…
   
   Answered ✓
   DataMesh
   Add Ons and Integrations
   157
   1:00 am
   6
   

 
«1234567…100»
Hey! You will be signed out in 60 seconds due to inactivity. Click here to
continue using the site.

QUICK LINKS


 * Recent Discussions
 * Activity
 * Badge Dashboard
 * My Bookmarks0
 * My Discussions0
 * My Drafts0
 * Trending
 * Unanswered44
 * Groups

CATEGORIES

 * All Categories
 * 13 Welcome to the Community
 * 8.5K Get Help
 * 37 Global Discussions
 * 366 Announcements
 * 8 Community Corner Newsletter
 * 3.2K Ideas & Feature Requests
 * 49 Brandfolder
 * 116 Just for fun
 * 48 Community Job Board
 * 458 Show & Tell
 * 39 Member Spotlight
 * 43 Power Your Process
 * 30 Sponsor X
 * 225 Events
 * 7.3K Forum Archives

POPULAR TAGS

 * Formulas 11,815
 * Project Management 4,506
 * Sheets 3,978
 * Reports 2,802
 * Forms 2,616
 * functionality 2,274
 * Automations 2,241
 * IT & Operations 1,763
 * Enhancement Request 1,642
 * Cell linking 1,615
 * Support 1,608
 * Email Notifications 1,539
 * Account and User Management 1,436
 * Dashboards 1,418
 * Integrations 1,280
 * Conditional Formatting 1,273
 * Construction 1,107
 * Workflows in Smartsheet 1,024
 * API and Developers 1,002
 * Sharing and Collaboration 960
 * Update Requests 892
 * Manufacturing 872
 * Attachments 837
 * Gantt View 835
 * Product Development 820

Member Spotlight
“Answering other people's questions and queries has clarified my understanding
of Smartsheet. It has helped me develop great workshops where I could highlight
the areas that users struggle with based on what I see in the Community.”
Debbie Sawyer

THIS WEEK'S LEADERS

 * 20 Points Nabiya
 * 15 Points Nadine_PrusLoughlin8
 * 10 Points Eriko
 * 10 Points gvattura
 * 6 Points Jo Vargas

THIS MONTH'S LEADERS

 * 700 Points Jared Agee
 * 675 Points Jean Egi
 * 654 Points Ric T
 * 650 Points Antonie B
 * 650 Points Erin Kim