Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Archived 2017 Posts
Archives for March 2017
Discussion List
-
Closed Jennifer Levey 11 views 4 comments 0 points Most recent by Jennifer Levey Archived 2017 PostsFirst post 03/31/17,Last post 04/04/17I have the following formula in a field to calculate a cost: =IF([Pre-ID]6, 5.18 * [Higher Qnty]6, 4.98 * [Higher Qnty]6) However, if the result of this calculation is not at least $300.00 I need the formula to insert $300 instead of …Archived 2017 Posts114Jennifer Levey -
First post 03/31/17,Last post 04/19/18I'm a very new user (1 week) and I am trying to apply conditional formatting if any one of 4 conditions is met. I need an OR statement but can't figure out how to do it, other than to do a separate rule for each condition. I searched the c…Archived 2017 Posts2133Megret
-
First post 03/31/17,Last post 04/02/17In order to test the very basic search functions in SmartSheet, I added a unique text string to the Comments section in a few records in a few different ways -- with text before it, with text after it (a period), and alone. The search …Archived 2017 Posts143SmartJason
-
First post 03/31/17,Last post 04/02/17Looking for suggestions / best practices to make the most of SmartSheet with an important client who is ALSO a huge SmartSheet user. First step they requested is a simple file repository - will grow from there...Archived 2017 Posts111John Randazzo
-
First post 03/31/17,Last post 04/04/17When I add a comment to a sheet, the "SAVE' button stays greyed out. This makes me think that comments won't be saved unless I do an additional action that enables the 'SAVE' button and then click the 'SAVE' button.Archived 2017 Posts573Paul Phillips
-
First post 03/31/17,Last post 03/31/17I am using a report system where "Assigned To" is Current User. I am just seeking clarification for how this works/updates if multiple people have the report open simultaneously? Thanks!Archived 2017 Posts361Brent Nathan
-
First post 03/31/17,Last post 04/03/17The option of when I "save as new" the new sheet doesn't copy over the notifications/reminders. As I roll about 20 sheets over each month, it is time consuming to set up all of the notifications/reminders. Please add. …Archived 2017 Posts114Ian
-
First post 03/31/17,Last post 02/08/18I would like to count the number of REDs for Parent cells only (not children). Any help would be much appreciated. (Image)Archived 2017 Posts52Brent L
-
First post 03/31/17,Last post 04/03/17I need to be able to assign different work periods to different line item tasks. We have some subs that work 8hr 5 day weeks and others that we accelerate for some work to do double shifts or 6 days a week. We also at times will add saturd…Archived 2017 Posts11Bill Brandt
-
First post 03/31/17,Last post 03/31/17When you import from MS Project do dependencies import?Archived 2017 Posts421Bill Brandt
-
First post 03/31/17,Last post 03/31/17I have a start date column, due date column, completed date and would like to have overdue flag column. How to set formula that if due date passes, no completed date and have flag come up in overdue column?Archived 2017 Posts8305Schultis
-
First post 03/31/17,Last post 04/03/17Hi I am calculating time spent on work by Job Number and by Date I have set up a SUMIF formula to add time spent by job number: =SUMIF([Job Nº]:[Job Nº], "64501", Time:Time) - Works fine. the formula to add time spent by date …Archived 2017 Posts34Hugh McKinney
-
Closed Kristof Pries 46 views 3 comments 0 points Most recent by Richard Rymill SBP Archived 2017 PostsFirst post 03/31/17,Last post 03/31/17Dear smartsheet team, the freezing of rows would be more than helpful! I am working with Smartsheet on various customer projects and a have a great demand for this feature! Is there a status on how this goes? I think its a frequently …Archived 2017 Posts463Kristof Pries
-
Closed Simon Hanlon 2 views 5 comments 0 points Most recent by Richard Rymill SBP Archived 2017 PostsFirst post 03/31/17,Last post 03/31/17If you have favourite formulas that you will use on multiple sheets can they be stored as template formulas or do you have to copy from a sheet each time you want to use the formula?Archived 2017 Posts25Simon Hanlon
-
First post 03/31/17,Last post 04/04/17Hi, Anyone that can help? I found the themplate: 'Simple Performance Review Template' on this Smartsheet website: https://www.smartsheet.com/free-employee-performance-review-templates But I can't find the template in the Human Resource …Archived 2017 Posts152Kristian Joos
-
First post 03/30/17,Last post 04/03/17I'm trying to set up a tool inventory, to help keep track of the location of all our big ticket items. I've created a row for each tool. Asides from various descriptive colums, I have one column set as a drop down list (listing the nu…Archived 2017 Posts432Grant Harvey
-
Closed Jacquie Hannibal 95 views 4 comments 0 points Most recent by Adam Overton Archived 2017 PostsFirst post 03/30/17,Last post 03/31/17Hi there, My first post to this forum and somewhat new user to Smartsheet. Can anyone advise if below is possible and if yes, how to do this or point me to help on this topic. Thanks a million! *** I want to create a template se…Archived 2017 Posts954Jacquie Hannibal
-
First post 03/30/17,Last post 04/03/17This is a MAJOR fail - that while you can set a field to a default value in the form, you can't do it in the sheet itself - !!!!! this is a FAIL! This should be addressed as soon as possible by your team.Archived 2017 Posts378ccianci
-
Closed Patricia Thurston 23 views 3 comments 0 points Most recent by J. Craig Williams Archived 2017 PostsFirst post 03/30/17,Last post 04/01/17Hi - I'm trying to figure out a formula that will pull in the next milestone date into a report or sheet. I want to include the project name, the milestone name, and the milestone date. I don't want to see all of the milestones, just the…Archived 2017 Posts233Patricia Thurston
-
First post 03/30/17,Last post 04/11/17It's going on 14 days and I still have no idea how to access the Solutions PM templates discussed in this webinar: https://www.youtube.com/watch?v=fGdbyfiYFZo Customer Support has been no help what so ever. Can anyone provide LINKS to…Archived 2017 Posts115Erin Glover
-
Closed Gary Systems Improvement 11 views 1 comment 0 points Most recent by Shaine Greenwood Archived 2017 PostsFirst post 03/30/17,Last post 03/31/17Anyone noticed that all trainging videos are so simple of solutions they really don't help with much beyond the most basic. Like conditional formatting - show me how to deal with wanting multiple columns to change format based on one c…Archived 2017 Posts111Gary Systems Improvement
-
Closed Jennifer Paquette 27 views 4 comments 0 points Most recent by Mike Wilday Archived 2017 PostsFirst post 03/30/17,Last post 03/30/17Trying to figure ouut how to alert the Owner when he/she is assigned a new Action Item on the SmartSheet. (Owner is a column linked to users). Want to avoid everyone (45+ users) getting an alert everytime an owner get a new assignment --…Archived 2017 Posts274Jennifer Paquette -
Closed Gary Systems Improvement 59 views 3 comments 0 points Most recent by Mike Wilday Archived 2017 PostsFirst post 03/30/17,Last post 03/31/17How do you make a roll-up of multiple indivdual projects. Wtihin each of the project dependencies is turned on.Archived 2017 Posts593Gary Systems Improvement
-
Closed Yovanka Barnard 74 views 2 comments 0 points Most recent by J. Craig Williams Archived 2017 PostsFirst post 03/30/17,Last post 04/01/17Hi All, I am wondering if some of you have ideas regarding setting up agendas for meetings. We have various sheets for example: Sales, Finance, Tasks, Schedules, etc. I want to design agendas for each weekly meeting. How c…Archived 2017 Posts742Yovanka Barnard -
First post 03/30/17,Last post 03/30/17I want everything that is under a Parent Row on a Sheet to show on our Dashboard. Is it possible to cell link ALL children under a parent row to a Sight/Dashboard? Examples: If any rows are added they will be included If only one r…Archived 2017 Posts243Laura -
First post 03/30/17,Last post 03/29/18I have a sheet for meeting action points and use update requests to keep on top of oustanding actions and mark and action complete when it is done. I have been trying to delete update requests on completed action s but have found you can o…Archived 2017 Posts2474Simon Hanlon
-
Closed Linda Burke 3.6K views 9 comments 0 points Most recent by J. Craig Williams Archived 2017 PostsFirst post 03/30/17,Last post 04/01/17I couldn't find an answer that solved my problem so am asking this question. I am trying to sum up a column where some of the fields are checked and some are not. Can you please help me? I have tried looking at the SUMIF calculations and k…Archived 2017 Posts36099Linda Burke
-
First post 03/30/17,Last post 03/31/17Hi relative newbie here... looking for help. I would like to set up time sheets for individual team members is a design studio. They will list jobs worked on by job number to allocate time worked on daily. I would then like to consolidate …Archived 2017 Posts174Hugh McKinney
-
Closed Patrick Galvin 116 views 4 comments 0 points Most recent by Patrick Galvin Archived 2017 PostsFirst post 03/30/17,Last post 04/07/17Is there any way to screen snip and have the snapshot saved as an attachment? The only way currently appears to be screen snipping and save into word and then attach or save as image and then attach thatArchived 2017 Posts1164Patrick Galvin
-
First post 03/30/17,Last post 09/13/19We have a contact column in our sheet with names and email addresses. I would like to export that information into excel but it will only export the names. Is there a way to get the email addresses?Archived 2017 Posts2983Van Ray