functionality
Discussion List
-
In a Gantt with many rows, how to color a date range that spans all rows in a column?In Using SmartsheetIn other words, I have a developed Gantt with many rows. There's an event that I'd like to track in the Gantt that occurs over the course of several weeks. I would like to highlight that date range but not just have it on one row, I want i…Answered - Pending Review 15 views 3 comments 0 points Most recent by Scott Rapoport Using Smartsheet
-
Dynamic View - New Item SubmissionIn Premium Apps and IntegrationsI'm creating a new view in Dynamic View and I have enabled new item submission as well as user can display and add attachments. Unfortunately when actually drafting a new item submission I do not see an option to add an attachment the same…Answered - Pending Review 86 views 4 comments 0 points Most recent by Ian Cooper Premium Apps and Integrations
-
Best practices / templates to create an NPS Form and DashboardIn Using SmartsheetGood afternoon, I need to create a form to measure Net Promoter Score (NPS) for our PMO office. I have samples for the questions, but I would like to know if anyone has experience building a form specifically to measure NPS. Any ideas/sug…
-
My column formula =COUNT(DESCENDANTS()) returns #BLOCKED in one cell. Is there a limit to the count?In Formulas and FunctionsAll other column formulas work fine. The only reason I can think of is there may be too many descendants? The value returned should be 1540. Is there a limit to the COUNT function?
-
Report Summary - New function isn't workingIn Using SmartsheetAccording to this https://help.smartsheet.com/articles/2482083-summarize-content-to-extract-key-information-with-report-builder I should be able to summarize my report based on ANY field. I am trying to summarize how many tasks an individu…
-
Has anyone used smart sheet to reconcile general ledger accounts to the subledger?In Formulas and FunctionsWanting to see if we took a report from our purchasing system and uploaded it to a Smartsheet, if it could compare to another sheet that is uploaded from a report from the finance system. I have looked through templates and template sets …Answered - Pending Review 18 views 1 comment 0 points Most recent by Genevieve P Formulas and Functions
-
How to have a Date and Time format for Date Column Properties?In Formulas and FunctionsHi, Do we have Date and Time format now for Date columns?Answered - Pending Review 917 views 13 comments 3 points Most recent by SJ Sellers Formulas and Functions
-
Hello hello - help with functionIn Formulas and Functionsthis function show all the unique names in one cell =JOIN(DISTINCT(Categories:Categories), " - ") Please i want show the data in different cells thanks ilyasAnswered - Pending Review 19 views 7 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
Row Change Notification Being Triggered by Rows Added Through FormIn Using SmartsheetHi there I've setup a notification that's triggered by a row change. However when a new submission is made via the form (i.e. a new row is added via the form) it's triggering the notification as well. The notification is: "Trigger: W…Answered - Pending Review 146 views 10 comments 0 points Most recent by Paul Newcome Using Smartsheet
-
Hello - third time asked for something i didnt get itIn Formulas and Functionsthe following formulla gave like this =(JOIN(DISTINCT({Task name}))) But the unique names not should in one list like this thanksAnswered - Pending Review 11 views 4 comments 0 points Most recent by ilyas star Formulas and Functions
