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
Don't miss our upcoming IT Thought Leadership Webinar: Ensuring Trust in a World of Hybrid WorkIn General AnnouncementsAs businesses continue to navigate new ways of working, the importance of a collaborative and secure remote workforce can’t be ignored. Join Chris Peake, CISO at Smartsheet along with Alissa Abdullah, Deputy CSO at Mastercard for a coffee… -
Announcement
Smartsheet University Is Here!In General AnnouncementsHi Community, We are excited to introduce Smartsheet University, a single platform for eLearning, live instructor-led training, in-person training, and custom training. Smartsheet University offers unique learning paths and meaningful con… -
Auto Number/SystemIn Using SmartsheetIf I want to set the Auto Number (Ref. No.) to start from the specific row, How can this happen? For example, If I want to start the no. from row 208
-
Is Smartsheet a centralized cloud-based platform?In Using SmartsheetIs Smartsheet a centralized cloud-based platform? How is it different from other cloud-based platforms? Thanks!
-
Find first non-empty cellIn Formulas and FunctionsHi, What formula can I use in the Current Email Helper column to accomplish the below Desired Outcome. I'm not using a hierarchy so I cant use CHILDREN()/PARENT() functions. Here's the kind of logic I'm trying to follow: IF [Email]@row is…Answered - Pending Review 35 views 5 comments 0 points Most recent by Andrée Starå Formulas and Functions
-
IFERROR not workingIn Using SmartsheetI've created an intake column to count the # of days based on a date in the Approval Request Submitted column. I want to use IFERROR to remove the INVALID DATA error and replace it with a "0" (zero). my attempts were; =IFERROR(…
-
Dashboard question- Can I add a list of locations to click on and all of the widgets update?In Formulas and FunctionsLike in excel pivot tables, how you can add a 'slicer' and then all of the pivot tables you've connected to it- will update their data based on the item you filter/click on.Answered - Pending Review 6 views 1 comment 0 points Most recent by Andrée Starå Formulas and Functions
-
COUNTIF of CHILDREN with HASIn Formulas and FunctionsI'm running into an issue with a formula that I'm trying to write that counts the results of a multi-dropdown column using the CHILDREN hierarchy. =COUNTIF(CHILDREN([Event Tier]165), HAS(@cell, "Tier 1: Off-Site Event")) I'm lo…Answered - Pending Review 7 views 1 comment 0 points Most recent by Andrée Starå Formulas and Functions
-
Referential IntegrityIn Using SmartsheetIs deleting a record from one database possible even if it si linked to another database ?
-
-
Nested MAX formulaIn Formulas and FunctionsIs there a way to use the MAX formula to look at a created column and check a box for the last entry of each day? I'm having no trouble getting the MAX to work for the full sheet, but it's not working for each day. I'm looking at the cre…
-
Data shuttle & Unchanged RowsIn Apps, Integrations, and Add OnsHello! I am trying to think of a simple way to highlight rows in my target sheet that are no longer in my source sheet. I know I can have them deleted but I am trying to see if there is an option where they stay on target sheet until I del…Accepted Answer 19 views 2 comments 1 point Most recent by Joseph Gentile Apps, Integrations, and Add Ons
