Discussion List

• OneNote integration in Smartsheet

  In Apps, Integrations, and Add Ons

  Based on a suggestion I read on this board, I am posting a product enhancement request I just submitted for the community to see. Request OneNote integration in Smartsheet to easily paste in a link to a OneNote page/paragraph/section/sec…

  Craig Moss

  05/04/22

  3914 11

  3.9K views 11 comments 1 point Most recent by Ben Hurst 05/04/22Apps, Integrations, and Add Ons
• Remove Primary Column From Report

  In Using Smartsheet

  I am running a report from my sheet however the primary column shows up even though I did not select it and I cannot hide it. I don't want/need it in my report. I was wondering if there was a way to remove or prevent it.   Thanks!  

  Sgiovinazzo

  04/25/22

  1583 10

  1.6K views 10 comments 0 points Most recent by Genevieve P. 04/25/22Using Smartsheet
• Formula to count of items in a multi dropdown list

  In Formulas and Functions

  Hi The drop-down multi select is very nice and useful.  I started to use it yesterday, but I need to use the formula =countif(range, criterion).  I want to count how many times a value is repeated in a range that has multi values. I use …

  lcamacho19911

  04/01/22

  Accepted

  30639 44

  Answered ✓ 30.6K views 44 comments 0 points Most recent by Paul Newcome 04/01/22Formulas and Functions
• Dynamic View Search Functionality

  In Using Smartsheet

  Our team often needs to search by program, client or product numbers.  I can't find a way to do this in Dynamic View other than Ctrl+F, which only returns results that are currently visible on the screen/window.  Any suggestions?

  S_Karkhoff

  03/28/22

  431 3

  431 views 3 comments 1 point Most recent by Alan P. 03/28/22Using Smartsheet
• Add Actual start and completion date based on status column

  In Formulas and Functions

  All,   I want to fill date column based on status column. 1) If status is  "In Progress" "Actual Date" is filled by today's date. 2) If status is "Completed" then "Completion date" is filled by t…

  jitendra.khatri102252

  02/05/22

  425 6

  425 views 6 comments 0 points Most recent by Mike Wilday 02/05/22Formulas and Functions
• Changing a cell's values from code in a different cell

  In Formulas and Functions

  Is it possible to change the value of a certain cell using code in another cell. I would imagine it looking similar to this format.. IF([email protected]=X, different_cell=XX, different_cell=XXX)

  logan.boese

  12/28/21

  426 5

  426 views 5 comments 0 points Most recent by Andrée Starå 12/28/21Formulas and Functions
• Outlook Integration not installing

  In Using Smartsheet

  Inside of Outlook, I have clicked "Store Add-ins", found "Smartsheet for Outlook" and clicked that. I then clicked the blue "Add" button. This then briefly changes to "Adding..." then to "Added&…

  Ben Donahue

  09/07/21

  101 5

  101 views 5 comments 1 point Most recent by msfeltontoth 09/07/21Using Smartsheet
• Warning message when Duplicate entry is done through form

  In Formulas and Functions

  Is there a way to get pop up message saying there is a duplicate entry of the line u entered through form. Something avoids duplicate entry.

  prathap.krishnashetty69881

  08/05/21

  Answered - Pending Review

  1535 17

  Answered - Pending Review 1.5K views 17 comments 0 points Most recent by Genevieve P. 08/05/21Formulas and Functions
• Can Formulas Reference Reports?

  In Formulas and Functions

  I'm trying to see if formulas can reference reports or just root SS. I ran a report for all late tasks assigned to all people in a department. I then wanted to use a COUNTIF formula that would sum up all the late tasks of a certain person.…

  UnaB

  07/22/21

  3333 13

  3.3K views 13 comments 2 points Most recent by Daniel Heidt 07/22/21Formulas and Functions
• Delete and Lock row

  In API & Developers

  Dear All I would like to know. Is it possible, if I want my team can edit the row but they can't delete it?

  LY Visal

  07/21/21

  33 2

  33 views 2 comments 0 points Most recent by Brad Jones 07/21/21API & Developers