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
-
#Invalid Data Type for identical formula on one sheet that works on another sheetIn Formulas and FunctionsHello, I have two identical sheets to collect application data, each for a different project type. We'll call them Sheet 1 and Sheet 2. They both reference the same budget request sheet. I have a "Budget Submitted" column on each…
-
Limiting Values Visible in Form/Dynamic View Fields?In Premium Apps and IntegrationsGiven a column that uses a series of predefined dropdown values, is it possible to specify which of these may be selected from a Form or from a field within a Dynamic View? I don't want to present all options to users.Answered - Pending Review 12 views 1 comment 0 points Most recent by Sean Morgan Premium Apps and Integrations
-
Calendar AppIn Premium Apps and IntegrationsHi! I'm new to the Calendar App. I was wondering if there is a way to show time blocks on the calendar. When I send to iCal to view in Outlook, everything shows up in the banner meaning everything is an all day event when it isn't. Not …Answered - Pending Review 20 views 1 comment 0 points Most recent by Sean Morgan Premium Apps and Integrations
-
URGENT Need for helpIn Using SmartsheetHello all, I understand this might not be the real place to ask my question, but am stuck and in need of help. My scubscription ends in a few days, and I am having trouble chenging my credit card details on smartsheet site. I have alre…
-
Global Automation Permissions?In Formulas and FunctionsAre there global automation permissions, where the Limited option can be set across the board? All I could find was Permissions in Security & Controls. For any new sheet created, I want to default the Automation Permissions setting to …
-
Report not filtering out all 100% complete tasksIn Using SmartsheetI have a report to show me all of the tasks that are in progress (not 100% complete) or not started within a timeframe. Therefore, the report is supposed to filter OUT all tasks that at 100% complete. It has been working for over two year…
-
Last Week's ValueIn Formulas and FunctionsHi All, Does anyone know of a formula that can pull the values from an existing column from the week prior using the cell history or activity log? e.g. I can see the value last week in the cell history but I want to pull it automatically…Answered - Pending Review 13 views 2 comments 0 points Most recent by JeremiahHorstick Formulas and Functions
-
Email to Smartsheet to create new row in SheetIn Using SmartsheetI'd love to have a discreet email address tied to a sheet so that I could forward it emails as a way to create new tasks. I can't get force people to use a form so it would sure be handy to just set a rule that forwards to an email address…Answered - Pending Review 13 views 1 comment 0 points Most recent by JeremiahHorstick Using Smartsheet
-
What's wrong with my formula?In Formulas and Functions=COUNTIFS(Position2:Position196, CONTAINS("Medical Assistant", @cell), [Cleared to Return?]2:[Cleared to Return?]136, OR(CONTAINS("No", @cell), CONTAINS("Contingent", @cell)))Answered - Pending Review 19 views 2 comments 0 points Most recent by Mike Wilday Formulas and Functions