Other
Discussion List
-
How do I hide the sidebar/shared with bar?In Using SmartsheetIs there anyway to hide the left sidebar or workspace shared to bar in this new update? I can't see the names of anything unless I zoom out from the entire window.
-
How do I get a sum for each location (Room 600-605) excluding expired materials?In Formulas and FunctionsIn this first image the "Complete Count QTY" column sums the materials excluding expired materials. This works perfectly. In this image you can see my attempt at getting a sum for Room 605 in the "Location Specific QTY"…
-
Open a Hyperlink In Excel AppIn Apps, Integrations, and Add OnsI have a sheet with a SharePoint link to an Excel file in a cell. When I click on that link, it opens by default in the Excel online app. Is there a way to change the default so that it opens in Excel's desktop version?Answered - Pending Review 27 views 1 comment 0 points Most recent by Gia Thinh Apps, Integrations, and Add Ons
-
#DIVIDE BY ZERO Error - other resolutions not workingIn Formulas and FunctionsI am trying to resolve a #DIVIDE BY ZERO error. I've seen the other resolutions, but they are not working for me. Here is the formula that I am using: =ROUNDUP(([Anchor Install Hours]@row / {Amazon - Brownfield - Priority Sites - Set Rang…
-
Form Validation - Phone Number Default to Canada?In Using SmartsheetThought I would ask here before contacting Smartsheet Support (as I'm hoping someone else has had this problem, and has a resolution). I've built my form, and added 'Phone' as the Validation. The problem I'm facing, is that I've changed …
-
INDEX and MATCH across two sheets: a detailed explanationIn Best PracticeHello everyone, would love some feedback on this tutorial. I was answering a user's question regarding INDEX and MATCH (thread post here), and thought it would be beneficial to share my example to the greater Smartsheet community of how to…
-
Automation Suddenly Not WorkingIn Using SmartsheetI have an "Request Approval" workflow I created back in August 2019 that was working perfectly fine until late last week. I can't find any reason for it. Nothing was changed on our end. Is anyone else having automation problems??Answered - Pending Review 440 views 11 comments 0 points Most recent by David Horowitz Using Smartsheet
-
Dashboard | How do I continue Numbering List when I made a Bulleted list in between numbers.In Using SmartsheetI want to make Numbered list from 1 - 5, and for Item number 2, I need to have 3 sub category (list). But when creating number 3, it defaults to Number 1 even when pressing the Number List Icon. Please advise.
-
Is there a way to highlight values by month or display values by month in a gnatt view?In Using SmartsheetThe screenshot above is done in EXCEL, and its calculating the allocation% percentage of each project by month for an individual. It also has a blue bar that highlights the months that have values in it. I am trying to replicate this in sm…
-
Back up not completeIn Using SmartsheetI requested a back up of my smart sheet on the 24th. It is still pending. Who do I contact to get that back up. Smart sheets won't let me attempt another back up with that one still pending.
