Using Smartsheet
Archives for April 2020
Discussion List
-
Possible to create multiple linked templates?Accepted AnswerAccepted Answer David Slaughter 1 view 3 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 04/30/20,Last post 05/01/20Hi All, Hoping there's a few Smartsheet super users out there that can help! I've created a pretty flash client specific dashboard which pulls in from one master project template, which is is also linked to about another 10 seperate re…Using Smartsheet13David Slaughter -
Answered - Pending Review Colin Sledge 1 view 1 comment 0 points Most recent by Andrée Starå Using SmartsheetFirst post 04/30/20,Last post 05/01/20When sending an Update Request, is it possible to change the From person? My sheet was created by someone else but I want to set up a reminder update request that would appear to come from me instead of the owner. I'm currently an Admin on…Using Smartsheet11Colin Sledge
-
Importing Excel Spreadsheets into SmartsheetAccepted AnswerAccepted Answer Penny Wilson 71 views 7 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 04/30/20,Last post 05/06/20I am trying to automate a function that we desperately need. We have a spreadsheet that is generated every morning and every night. I want to import it into a Smartsheet that I will use for a Dashboard. My problem is that every time I i…Using Smartsheet717Penny Wilson
-
Answered - Pending Review rudolph.brouwer83256 12 views 5 comments 0 points Most recent by Paul Newcome Using SmartsheetFirst post 04/30/20,Last post 05/01/20Hello, I would like in a form input a tagnumber like 1212122. Then after the form is submitted smartsheet will lookup this tagnummer in the main sheet. Then if found move the complete content of that row to another sheet and ( not just t…Using Smartsheet125rudolph.brouwer83256
-
Display a message / Instructions if cell is emptyAccepted AnswerFirst post 04/30/20,Last post 05/01/20If I have a cell that needs input, like a persons name, but if that info is not filled out based on another column how would I make it generate or display a message? I have column - Plates Made By, I want a message to display if this info …Using Smartsheet111Chris Kidd
-
Announcement Anna Mkrtchyan 245 views 2 comments 0 points Most recent by Paul Newcome Using SmartsheetFirst post 04/30/20,Last post 05/08/20Missed the webinar? Review the recording in the Smartsheet Learning Center. Top 5 tips for optimizing your sheets. Learn best practices for getting the most out of your Smartsheet, including sheet structure, collaborating in a variety of w…Using Smartsheet2452Anna Mkrtchyan -
Automation Copy RowsAccepted AnswerAccepted Answer Angela Logie 31 views 9 comments 0 points Most recent by Paul Newcome Using SmartsheetFirst post 04/30/20,Last post 05/21/20Is there a way, when using the automation copy rows, to select which rows to copy from a sheet instead of it copying all rows?Using Smartsheet319Angela Logie -
Recurring TasksQuestionAnswered - Pending Review Jerry Tice 31 views 1 comment 0 points Most recent by Andrée Starå Using SmartsheetFirst post 04/30/20,Last post 05/01/20I would like to create a recurring task on a gantt chart without having to create multiple lines. I don't believe this is a feature so can I ask that this feature be put on the list for future.Using Smartsheet311Jerry Tice
-
Answered - Pending Review Jerry Tice 11 views 1 comment 0 points Most recent by Andrée Starå Using SmartsheetFirst post 04/30/20,Last post 05/01/20I have several projects that were suspended due to Covid issues but are starting to open back up. I have to push out everything due to this suspension and I would like to highlight (or just delete/hide) those date columns during the suspen…Using Smartsheet111Jerry Tice
-
Locking a Formula in a ColumnQuestionAnswered - Pending Review Samantha Timko 53 views 2 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 04/30/20,Last post 05/01/20I created a formula in a column that I do not want people to be able to change, but to still function as people add new information in the rows. By locking the column, will the formula still work (the cell will still populat/update) when…Using Smartsheet532Samantha Timko
-
Update Request LinksQuestionAnswered - Pending Review Mike Rini 31 views 12 comments 0 points Most recent by ipeat Using SmartsheetFirst post 04/30/20,Last post 06/09/20Hi - I'm wondering if there's any way to capture the actual Update Request link (what comes through in the email when you send the Update Request) in a report? Our account people get tons of Update Requests, and don't always have the info…Using Smartsheet3112Mike Rini
-
A workflow has become invalidQuestionAnswered - Pending Review paulen 32 views 1 comment 0 points Most recent by Andrée Starå Using SmartsheetFirst post 04/30/20,Last post 05/01/20Hello, I have had this problem for over a month! I receive the notification "A workflow has become invalid" and I go to the workflow, delete it and do it again. It works for a while and then it happens again. I already set the …Using Smartsheet321paulen
-
Answered - Pending Review Jim Hatton 11 views 1 comment 0 points Most recent by Alejandra Using SmartsheetFirst post 04/30/20,Last post 05/05/20Hello, i am trying to set up a project request form which requires authorisation and once this is recieved it pushes fields through to 10000ft as a new project. I can see how to send info through to Slack and MS Teams, but not 10000ft. Ca…Using Smartsheet111Jim Hatton
-
Form input to a categorized viewQuestionAnswered - Pending Review Amy Evans 21 views 1 comment 0 points Most recent by Andrée Starå Using SmartsheetFirst post 04/30/20,Last post 05/01/20(Image) I'm using the Project Mgmt Office template. I'd like my form data to populate a sheet that looks like the above screenshot. Can a new form submission populate child rows under "New" category? And, once the status of proj…Using Smartsheet211Amy Evans
-
Answered - Pending Review Morgan Rolfes 11 views 6 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 04/30/20,Last post 05/14/20I set up an automation work flow to send an update request if a cell was blank or contained certain dropdowns. However, it did not send this morning like I set it up to do. I did the same thing on Tuesday for different thing and it worked.…Using Smartsheet116Morgan Rolfes
-
Answered - Pending Review Campbell-Trimbur 12 views 1 comment 0 points Most recent by Alejandra Using SmartsheetFirst post 04/30/20,Last post 05/04/20I have a contact list field that I use on a form. The list has 90 contacts, but in the sheet only 50 values are available. Why is this? This value is almost always populated from the form, which is good, but sometimes I need to change the…Using Smartsheet121Campbell-Trimbur -
Answered - Pending Review vasiles.kiosses75516 72 views 9 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 04/30/20,Last post 05/15/20Fellow Smartsheet users. I have been given an interesting challenge recently. A group gave me an excel file which a single sheet. It is built like an on-boarding form that has a series of elements. I thought it would be 2 dimensional howe…Using Smartsheet729vasiles.kiosses75516
-
First post 04/30/20,Last post 07/23/20I have come back to SS after a year or so and am enjoying using except, my main bugbear from last time has not be fixed! The width of the text when printed (or pd fing) does not reflect what's in my SS model. Lots of additional space in co…Using Smartsheet111Richard Genet
-
Answered - Pending Review Mike Feighan 21 views 3 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 04/30/20,Last post 05/06/20Hi I am migration a large data set from excel into smartsheet and this includes the history of all the comments over the years. I have converted the comments to a single row for ease of import. Each row has a unique ID that links to the c…Using Smartsheet213Mike Feighan
-
Answered - Pending Review Nicolas Raffray 32 views 1 comment 0 points Most recent by Andrée Starå Using SmartsheetFirst post 04/30/20,Last post 04/30/20Hi, I'm quite new to workflow and I'm trying to achieve the following: A document need to be signed by 2 signatories, signatory 1 received an automated update request from workflow 1 which works well. I want workflow 2 to automatically req…Using Smartsheet321Nicolas Raffray
-
Answered - Pending Review Philip Hanekom 13 views 1 comment 0 points Most recent by Alejandra Using SmartsheetFirst post 04/30/20,Last post 05/04/20Hi, I'm using the project template pack as a start, but frustratingly the "template contacts" still appear as history in the contact column, as well as some contacts I added then removed: (Image) None of these are in my Account&…Using Smartsheet131Philip Hanekom
-
repeat a subset of tasks in the same projectAccepted AnswerAccepted Answer Timothy Mather 11 views 4 comments 0 points Most recent by Elizabeth Jones Using SmartsheetFirst post 04/30/20,Last post 06/29/20Apologies if I missed this question elsewhere. I've created a 60-line set of tasks and subtasks with all dependencies flowing from a single final content delivery date. My overall project has 30 deliverables that all use this identical wor…Using Smartsheet114Timothy Mather
-
Answered - Pending Review Cheryl Crouse 33 views 1 comment 0 points Most recent by Alejandra Using SmartsheetFirst post 04/30/20,Last post 04/30/20I am US based and the majority of my projects are US based, however, my most recent and my main project at the moment is in Australia, so I have set my Personal Settings for Time Zone and Regional Preferences to Australia. Yesterday I cre…Using Smartsheet331Cheryl Crouse
-
First post 04/29/20,Last post 05/11/20I created a form to collect data from users (while at the same time protecting my sheet). I need to collect data from users on a monthly bases, and I'd like to be able to send the Form I created at the beginning of every month. I also hav…Using Smartsheet623Angelo Cordero
-
Conditional change to a cellQuestionAnswered - Pending Review Christina Reid 11 views 1 comment 0 points Most recent by Paul Newcome Using SmartsheetFirst post 04/29/20,Last post 04/30/20My sheet is setup with several columns but I need the formatting applied over two of them. Titles are NIGO date and is a date that the item was added to the sheet. The second is a drop it titled Advisor Action Needed and is a drop down l…Using Smartsheet111Christina Reid
-
Changing Colors on Bar ChartsQuestionAnswered - Pending Review Susan Swisher 54 views 23 comments 0 points Most recent by Paul Newcome Using SmartsheetFirst post 04/29/20,Last post 05/01/20Is there a way to change each row (separately) for a bar chart? when you change the colors, it changes every bar; I would love to change each bar, as a different color.Using Smartsheet5423Susan Swisher
-
CountIF Formula issueAccepted AnswerAccepted Answer Evan Summerville 31 views 3 comments 0 points Most recent by Jon Baier Using SmartsheetFirst post 04/29/20,Last post 04/30/20Greetings, I'm currently attempting to create a CountIF function that counts the number of Ungroomed Stories that start within the next 30 days. My formula is the following: =COUNTIFS([Issue Type]:[Issue Type], "Story", Labels:La…Using Smartsheet313Evan Summerville
-
First post 04/29/20,Last post 05/20/20Lets say I want a workflow that is when column QC Failure is checked it opens sheet QC Details that then can be filled in? Is this possible within SmartSheet to do?Using Smartsheet16Chris Kidd
-
Relative Default Date in FormsAccepted AnswerAccepted Answer Carmen Wong 13 views 5 comments 0 points Most recent by Paul Newcome Using SmartsheetFirst post 04/29/20,Last post 05/01/20I'm looking to do a 'Needed by' date in a form and I would like the default to be a relative Today + 2 weekdays. Anyone found a way to nicely do this? ie. Today is 4/29 , the form will default to 5/1 as the suggested Need by date that can…Using Smartsheet135Carmen Wong
-
First post 04/29/20,Last post 04/29/20In a workflow notification, is it possible to use a Smartsheet Group rather than only individual users? We have a sheet that we'd like to send an alert to group of people when something changes. The group membership changes frequently, so …Using Smartsheet113Susan B Peck
