Using Smartsheet
Archives for May 2020
Discussion List
-
First post 05/31/20,Last post 05/31/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 Smartsheet50Chuck Homola -
Sum formula not workingQuestionFirst post 05/30/20,Last post 05/30/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 Smartsheet40Jeana
-
First post 05/30/20,Last post 05/30/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 Smartsheet60Abhiraj Joshi
-
Count Up TimerQuestionFirst post 05/29/20,Last post 05/29/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 Smartsheet60Jaison Scott
-
Answered - Pending Review Jessy Martin 9 views 1 comment 0 points Most recent by Andrée Starå Using SmartsheetFirst post 05/29/20,Last post 05/29/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 Smartsheet91Jessy Martin
-
Answered - Pending Review Sandy Challman 12 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 Smartsheet121Sandy Challman
-
First post 05/29/20,Last post 05/29/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). https://us.v-cdn.net/6031209/uploads/X9CC78TID6RB/smartsheets-error-png.png Currently, I go into my…Using Smartsheet140Jean Ye
-
Answered - Pending Review Ashley Pierce 16 views 4 comments 0 points Most recent by Ashley Pierce Using SmartsheetFirst post 05/29/20,Last post 05/29/20https://us.v-cdn.net/6031209/uploads/ZDY6TLKNMPHW/annotation-17.png For example, for the DFM/DDFM Support Type, I would like to know that there are: Communication: (1) Ashley Pierce (1) Tanner May Proposal Review: (1) Alexa Briggs (2) Ashl…Using Smartsheet164Ashley Pierce
-
Answered - Pending Review Michael Heisler 13 views 2 comments 0 points Most recent by Michael Heisler Using SmartsheetFirst post 05/29/20,Last post 05/29/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 Smartsheet132Michael Heisler
-
Project RollupQuestionAnswered - Pending Review susannebankhead 17 views 2 comments 0 points Most recent by susannebankhead Using SmartsheetFirst post 05/29/20,Last post 05/29/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 Smartsheet172susannebankhead
-
Question Harriet Blackborow 9 views 0 comments 0 points Started by Harriet Blackborow Using SmartsheetFirst post 05/29/20,Last post 05/29/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 Smartsheet90Harriet Blackborow
-
First post 05/29/20,Last post 05/29/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? https://us.v-cdn…Using Smartsheet70Emma Smyth
-
Answered - Pending Review lisa.hollister84496 12 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! https://us.v-cdn.net/6031209/uploads/J4UK5UVOM7VT/ss-notifications-jpg.jpgUsing Smartsheet123lisa.hollister84496
-
COUNTIFS NON Blank QuestionQuestionAnswered - Pending Review Joel Brumback 16 views 3 comments 0 points Most recent by Paul Newcome Using SmartsheetFirst post 05/29/20,Last post 05/29/20I have two columns, "Assigned To" and "Date Entered". What I want is to count blank "Date Entered" cells that are assigned to a specific person. Is this possible?Using Smartsheet163Joel Brumback
-
Answered - Pending Review Vanessa Campos 13 views 1 comment 0 points Most recent by Andrée Starå Using SmartsheetFirst post 05/29/20,Last post 05/29/20I have a list of deliverables with a % complete column and I want to calculate the total number of: completed (at 100%) in progress (between 1% and 99%) not started (0%) I am using the following formula for completed and it is giving …Using Smartsheet131Vanessa Campos
-
Editing a templateQuestionAnswered - Pending Review Lisa_Doris 6 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 Smartsheet61Lisa_Doris
-
Count if offQuestionAnswered - Pending Review Scott Peloquin 8 views 1 comment 0 points Most recent by Mike Wilday Using SmartsheetFirst post 05/28/20,Last post 05/29/20I am trying to use a simple formula to count my number of different colored symbols in a column, RYG. I have many parent rows with 6 children each. 14 of the parent rows have a green symbol and all the others are currently blank, no symb…Using Smartsheet81Scott Peloquin
-
First post 05/28/20,Last post 05/28/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 Smartsheet130Meredith Luschen
-
Weekly tasks automation on task managementAccepted AnswerAccepted Answer Natasha Szczerb 15 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 Smartsheet153Natasha Szczerb
-
Answered - Pending Review Tiffanni Sanstra 14 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 Smartsheet147Tiffanni Sanstra
-
Answered - Pending Review Sandra Guzman 15 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 Smartsheet151Sandra Guzman
-
error when open dynamic viewQuestionAnswered - Pending Review Yashwant Singh 13 views 5 comments 0 points Most recent by Yashwant Singh Using SmartsheetFirst post 05/28/20,Last post 05/28/20Hi , Please check below error when open dynamic view ..please suggest... https://us.v-cdn.net/6031209/uploads/DK8I3UNL733B/image.pngUsing Smartsheet135Yashwant Singh
-
Answered - Pending Review Justin Guest 15 views 2 comments 0 points Most recent by Justin Guest Using SmartsheetFirst post 05/28/20,Last post 05/28/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 Smartsheet152Justin Guest
-
First post 05/28/20,Last post 05/28/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 Smartsheet90Trisha Martinez
-
Answered - Pending Review Ivy Chiu 10 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 Smartsheet102Ivy Chiu
-
Master work-flows in JIRA?QuestionAnswered - Pending Review Henry Kenton 12 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 Smartsheet122Henry Kenton
-
Answered - Pending Review Darwin Enriquez 8 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 Smartsheet81Darwin Enriquez
-
How to create a top five.QuestionAnswered - Pending Review Javier 19 views 2 comments 0 points Most recent by Javier Using SmartsheetFirst post 05/27/20,Last post 05/28/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 Smartsheet192Javier
-
Can you change "who" automatic alerts come from?Accepted AnswerAccepted Answer Toni Vohnoutka 17 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 Smartsheet172Toni 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 Smartsheet220beth_linder28141
