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
-
Auto Sort SmartsheetIn Using SmartsheetI've seen a few threads about this already, but none seem to have an acceptable solution. My particular use case is this: We have a Master Schedule sheet with over 100 active projects (this sheet is updated by various project managers). E…
-
REPORT: Grouping problemsIn Using SmartsheetSince the last update of the platform the grouping feature seems not working properly in some sheets. It says as attached that means "To see lines in every group change the filter criteria to reduce lines from 72" I do not und…
-
COUNTIF or COUNTIFS formula for a date column, criteria based off MONTH and YEARIn Formulas and FunctionsI am trying to total the number of completed submissions on my Ankeny Repair spreadsheet based off of a specific month from a specific year. Range 4 is the column with the completed dates. My current formula is this... =COUNTIFS(MONTH({Ank…
-
Current Week and Next Week FormulaIn Formulas and FunctionsHi, I need help with a formula that will help me determine if a date is the current week or the next week in the calendar. Need the weeks to star on Sundays. I'm using the following two formulas: For Current Week I'm using the following fo…Answered - Pending Review 19 views 2 comments 0 points Most recent by Rajul Khandelwal Formulas and Functions
-
Attachments in notesIn Using SmartsheetCan attachments be attached to a note or message line in SmartSheet and when you use the @ symbol will it email the attachment as well or at least let the person know you attached something? I cant seem to add a comment and have the pers…
-
Smartsheet to Alteryx connectionIn Premium Apps and IntegrationsHi there, Does anyone have any info of how to link up smartsheets to Alteryx, so that Alteryx is able to pull in information from Smartsheets? Thanks in advance!Answered - Pending Review 10 views 1 comment 0 points Most recent by Andrée Starå Premium Apps and Integrations
-
Report MessageIn Using SmartsheetWhy do I get this message every time I access a report for the first time since logging in?? My report already exists and I have to click on Get Started and then click out of the folder selection box to continue with my report.
-
Formulas to identify duplicatesIn Formulas and FunctionsMy company is assigning decals to vehicles to monitor our guests. Is there a formula to identify if a license plate has already received a decal if I am looking at my sheet? We will have 2000+ license plates and need this to be a quick gla…Answered - Pending Review 16 views 1 comment 0 points Most recent by Andrée Starå Formulas and Functions
-
Question on IF / AND OR FormulaIn Formulas and FunctionsHello, I have this formula that works great. I would like to add one criteria to it, however. If a new column (not currently referenced here, which contains a "priority status" (different than "status") that is "hi…Answered - Pending Review 15 views 1 comment 0 points Most recent by Andrée Starå Formulas and Functions
-
IF #INVALID OPERATIONIn Formulas and FunctionsHi I am using this formula to define Health of the project with symbols in the summary sheet =IF([Gap vs SMS]15 >= 14, "Yes", IF(14 > [Gap vs SMS]15 >= 0, "Hold", IF([Gap vs SMS]15 < 0, "No"))) For…Answered - Pending Review 13 views 1 comment 0 points Most recent by Andrée Starå Formulas and Functions
