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
-
Workflow to be triggered when cell is changed to specific valueIn Using SmartsheetHi all, I would like to create a notification workflow to be triggered when cell is changed to specific value. Is this possible? Thanks in advance!!
-
workflow to be triggered when cell is changed to specific valueIn Using SmartsheetHi all, I would like to create a notification workflow to be triggered when cell is changed to specific value. Is this possible? Thanks in advance!!
-
Status Column FormulaIn Formulas and FunctionsHello Team, can you help me with status column formula to automate status column: Green = "% complete"=0% Blue = "% complete"= 100% Yellow = "Finish Date" >Today() but < Today () + 3d Red…Answered - Pending Review 27 views 5 comments 0 points Most recent by Rahul Bhandari Formulas and Functions
-
Graphing Only Total Row From Summary ReportIn Using SmartsheetI want to graph my summary row of my report; however, when I select the report it does not give me the option to modify what is selected to be included in the graph which is the entire report. This report is built of summary data from abou…
-
Dynamic View - ConversationsIn Apps, Integrations, and Add OnsHi Smartsheet Community I'm using Dynamic View to have multiple stakeholders approve an asset in parallel. I created a different view for each Stakeholder, which I'll call #1, #2, and #3. If #3 adds a comment on a row, will Stakeholders #1…Accepted Answer 24 views 5 comments 0 points Most recent by Andrée Starå Apps, Integrations, and Add Ons
-
Deleting an attachment by guest userIn Using SmartsheetJust a quick question, as a sheet owner I would think I could delete a row/card attachment placed there by a guest user, but it seems it's grayed out. Does anyone have a work-around for this? Also, is there a way for a guest to upload and …
-
Creating Reports from Different SheetIn Using SmartsheetHello team, I am trying to create a report from two different sheets. The concern that i am having is that in case i have same Columns in two sheets reports are picking these as two entries rather than single. So what basically i am lookin…
-
How to add Center of Excellence to the launcher button ?In Apps, Integrations, and Add OnsI've been looking for an apps suggested by a colleague, and we can't see the Center of Excellence in the search page. If somebody could help...Answered - Pending Review 21 views 2 comments 0 points Most recent by Genevieve P. Apps, Integrations, and Add Ons
-
How do I count how many projects a team member is working if the project lasts longer than a month?In Formulas and FunctionsSo, I'm trying to create a metrics sheet formula that will count the number of projects that occur in each month. In my resource planning sheet I am using as a reference I have a Project column, Assigned To, Start Date, End Date along wit…
-
Help with SUMIFS and COUNTAINS/MATCH/FINDIn Formulas and FunctionsI need help with a formula to Sum every instance a name appears in a multi-select row of a column. So from the screenshot, I want to Sum the No. of Hours claimed for each type of overtime reason. Using SUMIFS I have tried using : =SUMIFS(…Answered - Pending Review 17 views 3 comments 0 points Most recent by Genevieve P. Formulas and Functions
