Join the Smartsheet Community
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
-
Announcement
New! Add real-time validation to fields on your formIn Product AnnouncementsHi Community, We just enabled a forms enhancement that many of you have requested: field validation. You can now add real-time validation to Text/Number fields to help collect error-free numbers, percentages, email addresses, and phone num…Accepted Answer Announcement 82 views 10 comments 1 point Most recent by Olivier LEMBERT Product Announcements -
Index and match using dropdown, multi select column.In Formulas and FunctionsHello, I want to index and match off of a dropdown, multi-select column. If there are multiple selections in the dropdown I would like the project name to appear next to each individual name so that I can track assignments by the individua…
-
Automation QuestionIn Using SmartsheetHello Smartsheets Community: I was working on a couple of automations in a project plan that I am working on and I thought of one that could be useful. Being able to run an automation when a hyperlink is added to a task requiring work on …
-
formula - containsIn Formulas and Functionshi Guys i am trying a contains formula but doesn't want to work - what am i doing wrong? i need my REF column to get a 1 in if IF Dept contains REF if not REF then blankAnswered - Pending Review 13 views 3 comments 0 points Most recent by Genevieve P. Formulas and Functions
-
Problem with % format in a cellIn Formulas and FunctionsI have a cell in a summary sheet in which I am using a JOIN function simply to pull from another sheet. The cell in that sheet properly displays the data in a percent format (%) However the cell in my Summary sheet, displays the linked inf…Answered - Pending Review 9 views 4 comments 0 points Most recent by Andrée Starå Formulas and Functions
-
Form creationIn Using SmartsheetHi All Thank you in advance for taking the time to look into my issue. I need t to create a form to collect information, but I have an issue with the "registered mark" Is there a way to work around this? Masterpiece® Contact For…
-
Math formulas across multiple cellsIn Formulas and FunctionsHello all, Any help on the following issue would be very much appreciated. I have a scoring matrix built in to Smartsheet (See below). I would like to multiply the score of each cell for each criteria (Strategic Init Impact Score, Busines…
-
need a formulaIn Formulas and Functionshi Guys, me again, need a formula to count my netdays if Pass/Fail is a fail..... if a pass do nothingAnswered - Pending Review 9 views 1 comment 0 points Most recent by Andrée Starå Formulas and Functions
-
Help using a multiple cell criteria from a source sheet to auto populate a formula sheetIn Formulas and FunctionsI'm stuck. Really stuck. I've attempted more than 30 formulas. I hope someone can help me. I am using a master HR data file with 1500+ rows (reference/source sheet) to auto-populate a training enrollment roster (formula sheet), only I don'…
-
COUNTIFS with DISTINCTIn Formulas and FunctionsThis discussion was created from comments split from: Countifs with Distinct?.Answered - Pending Review 6 views 2 comments 0 points Most recent by Andrée Starå Formulas and Functions
