Using Smartsheet
Archives for May 2020
Discussion List
-
Accepted Answer Chuck Homola 11 views 2 comments 0 points Most recent by Chuck Homola Using SmartsheetFirst post 05/31/20,Last post 06/01/20I am building a workflow where I want to trigger an alert when the value in one column is less then the value in another column. How do I do that?Using Smartsheet112Chuck Homola -
Sum formula not workingAccepted AnswerFirst post 05/30/20,Last post 05/31/20Trying to sum cells in a row that have value based on a formula. I've read that this can be an issue and to use VALUE in the equation. However, I'm still getting a RED Zero as a result. Any ideas? =VALUE(SUM([Printing and Shipping]7, [Int…Using Smartsheet213Jeana
-
Answered - Pending Review Abhiraj Joshi 51 views 4 comments 0 points Most recent by Abhiraj Joshi Using SmartsheetFirst post 05/30/20,Last post 06/08/20Hi, I have about 80+ projects running simultaneously. In each project sheet, I have some basic project information & metrics (duration of each milestone calculated from actual start & finish dates) which needs to be tracked and ana…Using Smartsheet514Abhiraj Joshi
-
Count Up TimerQuestionAnswered - Pending Review Jaison Scott 53 views 7 comments 0 points Most recent by Paul Newcome Using SmartsheetFirst post 05/29/20,Last post 06/03/20Hey all. Brand new (3 days) Smart Sheet user. I am working on an exercise with my team and would like to have a running "count up" timer (stop watch if you will) in a dashboard that shows from the time we kicked off to where we a…Using Smartsheet537Jaison Scott
-
Automation based on Sheet SummaryAccepted AnswerAccepted Answer Jessy Martin 22 views 3 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 05/29/20,Last post 06/01/20Can I set up an automation based on a field in a sheet summary? What I'm ultimately trying to do is set up a review/approval workflow for an entire spreadsheet. Everything I've tried so far (adding status column to the sheet, using a sepa…Using Smartsheet223Jessy Martin
-
Answered - Pending Review Sandy Challman 11 views 1 comment 0 points Most recent by Andrée Starå Using SmartsheetFirst post 05/29/20,Last post 05/29/20I thought I was in a Report. BUT I was in a filter and I deleted several columns from a sheet. I do not have a backup. In the recent history it will not show the data in the columns either. HELP!Using Smartsheet111Sandy Challman
-
Answered - Pending Review Jean Ye 42 views 1 comment 0 points Most recent by Genevieve P Using SmartsheetFirst post 05/29/20,Last post 06/01/20Hi all, I'm having trouble embedding a powerpoint file in my Dashboard. Whenever I add the link, I get an error message (photo attached). (Image) Currently, I go into my powerpoint file, click File, and then Share -> Embed and copy/pa…Using Smartsheet421Jean Ye
-
Answered - Pending Review Michael Heisler 32 views 7 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 05/29/20,Last post 06/14/20Hello, is there a way to turn off this notification or any idea what can be causing this, there were only about 8 people in this at one time? (see below) It ends up taking over the screen and makes it difficult to work. This is just a no…Using Smartsheet327Michael Heisler -
Project RollupAccepted AnswerAccepted Answer susannebankhead 41 views 3 comments 0 points Most recent by Paul Newcome Using SmartsheetFirst post 05/29/20,Last post 06/01/20We're a small communications/creative agency using Smartsheet for project management for all our client work. Each client has a sheet created for projects, deadlines, team assignments. I have a dashboard created as a landing page with link…Using Smartsheet413susannebankhead
-
Answered - Pending Review Harriet Blackborow 23 views 2 comments 0 points Most recent by Harriet Blackborow Using SmartsheetFirst post 05/29/20,Last post 06/04/20Is there a way to set different working days for individuals? I know that it is possible to define working days through the Project Settings function but I want to set this for one person only to reflect their part time working structure -…Using Smartsheet232Harriet Blackborow
-
First post 05/29/20,Last post 06/01/20Hello We have multiple automations set that are working and we are receiving the reminders but for some reason for this specific automation we are not receiving the reminder. Is it because the row is being moved instantly? (Image)Using Smartsheet211Emma Smyth
-
Answered - Pending Review lisa.hollister84496 21 views 3 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 05/29/20,Last post 05/29/20Did something change? We rely quite heavily on these functions. Any insight would be appreciated. Thank you very much! (Image)Using Smartsheet213lisa.hollister84496
-
Editing a templateQuestionAnswered - Pending Review Lisa_Doris 12 views 1 comment 0 points Most recent by Andrée Starå Using SmartsheetFirst post 05/28/20,Last post 05/28/20Is there a way to edit a template or do I have to make the revisions from the sheet and save as a new template?Using Smartsheet121Lisa_Doris
-
Answered - Pending Review Meredith Luschen 11 views 1 comment 0 points Most recent by Genevieve P Using SmartsheetFirst post 05/28/20,Last post 06/01/20I'm using a form to collect shift information from employees (onto a master tracker). This shift information is filtered to 10 different reports, depending on the building and department. I need the user/employee to be able to modify the…Using Smartsheet111Meredith Luschen
-
Weekly tasks automation on task managementAccepted AnswerAccepted Answer Natasha Szczerb 21 views 3 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 05/28/20,Last post 05/29/20Hello, I'm optimising a task management sheet with automation and would like to know if there's a way to use automation to create a row? Some tasks are weekly, and it'd be great if they could be automatically added in every week, so the ow…Using Smartsheet213Natasha Szczerb
-
Answered - Pending Review Tiffanni Sanstra 42 views 7 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 05/28/20,Last post 05/28/20We have a form we would like to send to employees every morning, then be able to track each response separately. Tried automating the sending out of the form but when employees respond it overwrites the previous response because it was a …Using Smartsheet427Tiffanni Sanstra
-
Answered - Pending Review Sandra Guzman 46 views 1 comment 0 points Most recent by Mike Wilday Using SmartsheetFirst post 05/28/20,Last post 05/28/20Hello SS Community! I am a new admin currently responsible for managing our portfolio of work. I am loving SS and have been busy developing templates that my team will soon be using. The reason I am submitting this today is to find out wha…Using Smartsheet461Sandra Guzman
-
error when open dynamic viewQuestionAnswered - Pending Review Yashwant Singh 21 views 13 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 05/28/20,Last post 06/15/20Hi , Please check below error when open dynamic view ..please suggest... (Image)Using Smartsheet2113Yashwant Singh
-
Answered - Pending Review Justin Guest 32 views 3 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 05/28/20,Last post 06/01/20Hi, I have one sheet which has a form connected to it. Once someone submits the form, I have a drop down which I switch to "confirmed" when I have uploaded the submitters info. Once I select, "Confirm" I want two spec…Using Smartsheet323Justin Guest
-
Scheduling with Fixed Capacity ResourcesAccepted AnswerAccepted Answer Trisha Martinez 32 views 2 comments 1 point Most recent by Trisha Martinez Using SmartsheetFirst post 05/28/20,Last post 06/05/20I need to schedule project tasks by resource availability. All of the smartsheet resource management tools appears to assume there is always a resource available for the task, so the advice is simply to schedule another resource when one i…Using Smartsheet322Trisha Martinez
-
Answered - Pending Review Ivy Chiu 23 views 2 comments 0 points Most recent by cmondo Using SmartsheetFirst post 05/28/20,Last post 05/28/20As Blueprint cannot be removed thru UI... How to delete Blueprint in Configuration sheet?Using Smartsheet232Ivy Chiu
-
Master work-flows in JIRA?QuestionAnswered - Pending Review Henry Kenton 11 views 2 comments 0 points Most recent by Henry Kenton Using SmartsheetFirst post 05/28/20,Last post 05/29/20From what I can make out, I can only have a 1:1 for work-flows and sheets, and not a master work-flow which can be repeatedly used across all new sheets created. Is a master work-flow possible?Using Smartsheet112Henry Kenton
-
Answered - Pending Review Darwin Enriquez 2 views 1 comment 0 points Most recent by Genevieve P Using SmartsheetFirst post 05/28/20,Last post 05/28/20estoy usando la de muestra pero quiero pagar un mes plan individual pero no me permiteUsing Smartsheet21Darwin Enriquez
-
How to create a top five.Accepted AnswerFirst post 05/27/20,Last post 06/02/20Hi! I've working on a dataset for a while now that essencially logs the everyday orders we receive from our clients. One of the colums records the name of the customer and I've been trying to create a report that counts how many orders a …Using Smartsheet424Javier
-
Can you change "who" automatic alerts come from?Accepted AnswerAccepted Answer Toni Vohnoutka 48 views 2 comments 1 point Most recent by Susan B Peck Using SmartsheetFirst post 05/27/20,Last post 05/28/20Is there a setting to change the from field of an automatic alert email. Workflows/automations that I have set up myself always come from "my name via Smartsheet". It has caused some confusion to people receiving these automated …Using Smartsheet482Toni Vohnoutka
-
First post 05/27/20,Last post 05/27/20Now that the forms have had a good update, I would love to be able to add a conditional format OR use the one I have entered in another column. SO THAT the entry would show an error, or out of spec condition. For instance, operator enter…Using Smartsheet320beth_linder28141
-
Answered - Pending Review Jörg Schmidt 22 views 3 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 05/27/20,Last post 05/27/20Hallo, is it possible to put an automatic signature into "Email formula" when I send an update requestUsing Smartsheet223Jörg Schmidt
-
Reproducible HyperlinksQuestionAnswered - Pending Review Dennis Knipfer 43 views 3 comments 0 points Most recent by Mike Wilday Using SmartsheetFirst post 05/27/20,Last post 05/27/20I'm compiling a hyperlink section to include at the top of project sheets, a little more than a dozen in total. This collection creates my tabbed "Excel report". It will allow end users to navigate to the tabs/sheets they need. I…Using Smartsheet433Dennis Knipfer
-
Answered - Pending Review Susan Hildebrant 34 views 3 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 05/27/20,Last post 05/27/20I have created a form that requires a lot of information before it can be submitted. The person completing the form may not have all the information at hand or may get interrupted while completing the form. Is there a way the person can s…Using Smartsheet343Susan Hildebrant
-
Answered - Pending Review Paul Grim 55 views 16 comments 1 point Most recent by Paul Grim Using SmartsheetFirst post 05/27/20,Last post 07/22/20I am trying to insert a chart on a dashboard, using a report as the data source. However, when I select the report it does not allow me to select the data range I want (it defaults to select the entire report). What's more, it won't even …Using Smartsheet5516Paul Grim
