Using Smartsheet
Archives for July 2020
Discussion List
-
With no developer experience, is is possible to populate a form with information from a row?QuestionAnswered - Pending Review Taylor Riley 11 views 4 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 07/31/20,Last post 08/11/20I have a form for teams to fill out the requirements for a specific product. I would like them to be able to pull up the original information in the same Form format to submit any changes or additions. This would then essentially create a …Using Smartsheet114Taylor Riley -
Answered - Pending Review awollam105821 12 views 1 comment 0 points Most recent by Andrée Starå Using SmartsheetFirst post 07/31/20,Last post 08/01/20Over the past few weeks, I am frequently being kicked out of Smartsheet while in the middle of doing work. Saved (either auto save or manually saved) work are lost when I get back in. What is the fix for this? I asked other users that sha…Using Smartsheet121awollam105821
-
First post 07/31/20,Last post 07/31/20Hello, I am having some trouble with a query allowing me to look up values based on the name of an individual AND within a certain date range. The data table is weekly updated with new values, and has multiple fields, including name, date …Using Smartsheet122Art Kliatchko -
There was an issue connectingQuestionAnswered - Pending Review Chyslain E Nsufeu 36 views 1 comment 1 point Most recent by Гайко П Using SmartsheetFirst post 07/31/20,Last post 08/02/20Hi , I am using smartsheet-csharp.sdk version 2.101.0.0. When I consume my web application on my laptop and on a UAT, everything are working fine but I am having problem in production. The utility returning "There was an issue connec…Using Smartsheet361Chyslain E Nsufeu
-
Answered - Pending Review Alexander Gerasimenko 11 views 3 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 07/31/20,Last post 07/31/20I wonder if anyone else experience this issue and if Smartsheet changed access terms for Free collaborators. I recently created simple smartsheet and shared with 2 people, but they only see empty sheet. no content. any ideas ? how do i lo…Using Smartsheet113Alexander Gerasimenko
-
Calculated % CompleteQuestionAnswered - Pending Review Nigel Michell 13 views 2 comments 0 points Most recent by Nigel Michell Using SmartsheetFirst post 07/31/20,Last post 07/31/20We use three fields to indicate effort: Planned Effort Actual Effort Remaining Effort I created a column called '% Comp" with the following formula: =IF(ISBLANK([Remaining Effort (Hours)]@row), 0, IF([Remaining Effort (Hours)]@row = 0…Using Smartsheet132Nigel Michell
-
Contact ListQuestionAnswered - Pending Review Nigel Michell 43 views 2 comments 1 point Most recent by Nigel Michell Using SmartsheetFirst post 07/31/20,Last post 08/02/20Hi Another newbie question! I have updated the details for a contact in Accounts / My Smartsheet Contacts, eg I change the details for 'Nigel' to 'Nigel M' . Likewise, I also deleted a Contact. However, when I go back to my Project, the A…Using Smartsheet432Nigel Michell
-
Answered - Pending Review youngdonkey 113 views 5 comments 0 points Most recent by youngdonkey Using SmartsheetFirst post 07/31/20,Last post 08/07/20Hi, not sure if others are aware, but Smartsheet is not accessible from China right now. We have a major issue with one of our global customer's Chinese employees unable to update project information in Smartsheet. Hoping the community can…Using Smartsheet1135youngdonkey -
Answered - Pending Review Anna Pelipas 11 views 5 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 07/31/20,Last post 08/11/20Hi. Please help how could I get such a scenario: Trigger: a flag in a cell If the data in another exact cell in this row is equal to the data in another table's cell (that contains the preliminary data, autocopied to current table), then a…Using Smartsheet115Anna Pelipas
-
Answered - Pending Review SammyMorey 2 views 1 comment 0 points Most recent by Andrée Starå Using SmartsheetFirst post 07/31/20,Last post 07/31/20Hey community - we are constantly getting Aw Snap errors when we are trying to update and save one of our sheets. It does have a few conditional formats, but not many and same with automations. It is quite a large sheet with 5563 rows, bu…Using Smartsheet21SammyMorey
-
Answered - Pending Review KathrynLindsay 26 views 3 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 07/31/20,Last post 08/19/20I have a Master Sheet tracking new enquiries by a unique number, once they are logged here they move between several sheets moving through our divisions until they are finalised. I would like to be able to have a "tracking" colum…Using Smartsheet263KathrynLindsay
-
Conditional formatting to apply to any single cell containing specific text across multiple columnsAccepted AnswerAccepted Answer Jamie Bedford 14 views 2 comments 0 points Most recent by Jamie Bedford Using SmartsheetFirst post 07/31/20,Last post 08/04/20Hi there, Is it possible to create a single conditional formatting rule across multiple columns that would only apply to any single cell that matches the rule? For example, I may have a sheet with 10 or more columns for which I'd like a co…Using Smartsheet142Jamie Bedford
-
Accepted Answer Jamie Bedford 22 views 8 comments 0 points Most recent by Paul Newcome Using SmartsheetFirst post 07/31/20,Last post 08/05/20Hi there! Google Sheets have a very useful feature that lets you set a conditional color gradient (i.e., white to red, or red to green shadings, etc.) that adjusts based on either min/mid/max values or based on absolute values. Is this kin…Using Smartsheet228Jamie Bedford
-
Answered - Pending Review Lisa Krieger 11 views 1 comment 0 points Most recent by Andrée Starå Using SmartsheetFirst post 07/30/20,Last post 07/30/20I have a workspace that contains 104 sheets that is tracking the collection of documents that are uploaded to specific rows within the individual sheets. How can I create a report that tells me which rows are not completed on each sheet?Using Smartsheet111Lisa Krieger
-
Answered - Pending Review Alison Antisz 12 views 1 comment 0 points Most recent by Sean Morgan Using SmartsheetFirst post 07/30/20,Last post 07/31/20Why does Smartsheet not bring all columns of excel file when the document is imported? I noticed that the the first 7 columns came over fine but the next 7 did not appear at all. Some of the omitted columns have drop down menus and formu…Using Smartsheet121Alison Antisz
-
Answered - Pending Review Tamizamuthan Vedachalam 18 views 3 comments 0 points Most recent by Genevieve P Using SmartsheetFirst post 07/30/20,Last post 08/05/20We have installed Data Loader and connected Google Drive for testing purpose. Do we have option to restrict columns to be updated. Example - Source sheet is having 16 columns Target sheet is having 1 to 16 columns should extract data from …Using Smartsheet183Tamizamuthan Vedachalam -
Time controllingQuestionAnswered - Pending Review Alisa Zimels 12 views 1 comment 0 points Most recent by Paul Newcome Using SmartsheetFirst post 07/30/20,Last post 07/30/20We planed a rough schedule for our project. Now we need to plan new, because of the changes in the project. Also we want overlay the old plan with a new one so we ca see consequences. So I could see it is possible to add new columns and ch…Using Smartsheet121Alisa Zimels
-
Answered - Pending Review ilene_healy68056 12 views 1 comment 0 points Most recent by Ben G Using SmartsheetFirst post 07/30/20,Last post 07/30/20I would like to publish my calendar as read only "for anyone with a link" without showing the summary tasks. I have this set up correctly on the calendar settings, but when I publish all of the summary tasks display. Is this po…Using Smartsheet121ilene_healy68056
-
Answered - Pending Review Allie McDougall 14 views 3 comments 0 points Most recent by Tony Lucas Using SmartsheetFirst post 07/30/20,Last post 08/17/20We are looking to geocode street addresses that are entered into Smartsheet.Using Smartsheet143Allie McDougall
-
Answered - Pending Review Antoinette Arcella 12 views 2 comments 0 points Most recent by Genevieve P Using SmartsheetFirst post 07/30/20,Last post 07/30/20Just wondering if there is any possible way I can apply logical formatting within a sheet? ie I have several drop down columns and I want to be able to select one and the responses will be trigged within the other columns. If 'not yet star…Using Smartsheet122Antoinette Arcella
-
Answered - Pending Review Pamela Wagner 12 views 5 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 07/29/20,Last post 08/01/20I have an invoice that has 2 levels of approval on it but when I get a test email from the workflow I see that it only has the the column headers on it but no way to see the actual data without going out of the view request and into the sh…Using Smartsheet125Pamela Wagner
-
Answered - Pending Review Charles L 23 views 3 comments 0 points Most recent by Genevieve P Using SmartsheetFirst post 07/29/20,Last post 07/30/20I am getting errors when attempting to invite a user to smartsheets. The error "[email protected]" is currently a licensed user in Smartsheet. To add them to your account, grant them a license" I do not want to grant them…Using Smartsheet233Charles L
-
Answered - Pending Review SteCoxy 22 views 1 comment 0 points Most recent by Paul Newcome Using SmartsheetFirst post 07/29/20,Last post 07/29/20Hello, I've had a colleague come to me with a query about how best to link 2 sheets. Her enquiry includes a handy diagram: (Image) I'm wondering if cell linking would be best bet here? I realise this would obviously require her to keep hav…Using Smartsheet221SteCoxy
-
Answered - Pending Review Julie Rhodes 12 views 1 comment 0 points Most recent by Paul Newcome Using SmartsheetFirst post 07/29/20,Last post 07/29/20We have recently had a hack into our computer system and an entire sheets content was deleted. Is there a way to restore the sheet entirely?Using Smartsheet121Julie Rhodes
-
First post 07/29/20,Last post 07/30/20Hi, The ability to use forms and the logic options are really amazing tools. I see how the use of forms can increase the productivity of my team and eliminate a lot of emails back and forth with our clients. One use case we have is that …Using Smartsheet241Matt K
-
Resource ManagementAccepted AnswerAccepted Answer Nigel Michell 12 views 2 comments 0 points Most recent by Nigel Michell Using SmartsheetFirst post 07/29/20,Last post 07/30/20If multiple resources are assigned to a Task, and the % Allocated is different for each resource, I assume that the only way that this can be correctly recorded in Smartsheet, is to duplicate the Task a number of times so that each Resourc…Using Smartsheet122Nigel Michell
-
Updating sheet data before copying rowAccepted AnswerAccepted Answer Werner Gerstacker 22 views 27 comments 0 points Most recent by Mike Wilday Using SmartsheetFirst post 07/29/20,Last post 08/27/20I have an intermediate sheet with only one row that pulls the results of some calculations from my master data sheet in order create an archive entry. This intermediate sheet has an automation set up to copy the row into my archive sheet a…Using Smartsheet2227Werner Gerstacker
-
Accepted Answer Lori O'Daniel 14 views 5 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 07/29/20,Last post 07/29/20As the Question above reads. I have a Dashboard I am creating as well as some specific sheets. The sheets can be saved as a Template. But, I do not see an option for the Dashboard. If Dashboard cannot be saved as a Template. Does that mean…Using Smartsheet145Lori O'Daniel
-
can created by be change?Accepted AnswerAccepted Answer Benjamin Chua 3 views 5 comments 0 points Most recent by Paul Newcome Using SmartsheetFirst post 07/29/20,Last post 07/29/20so i have users entering data and it records their email address as created by, but sometimes a record is not being recorded and admin will fix it. it shows the admin's email address in created by, how do send an update to the users so th…Using Smartsheet35Benjamin Chua
-
Auto fill form for status updatesAccepted AnswerAccepted Answer sravya.gupta127326 3 views 8 comments 1 point Most recent by Andrée Starå Using SmartsheetFirst post 07/29/20,Last post 07/29/20Hi, I am creating a form for our weekly status updates so we can see the history. However, it would be useful to have default values pre populated in the form from last week's update so the PMs can update it instead of writing it again - i…Using Smartsheet38sravya.gupta127326
