Using Smartsheet
Archives for January 2020
Discussion List
-
First post 01/31/20,Last post 02/01/20I have seen discussions many users are asking this functionality. Do anyone know if there is any update roadmap to make cell merge possible? This is very basic feature of any smart or non-smart sheet :) Thanks WadeUsing Smartsheet161Wade Monavari -
First post 01/31/20,Last post 02/13/20I would like to back up a sheet that contains two system generated columns, Created By and Last Modified By, which currently are populated for all of the rows. When I tried saving the current sheet as a new sheet, all of my rows in the ne…Using Smartsheet262Win LeDinh
-
After join two smartsheets files into one the formatting disappears.Answered QuestionFirst post 01/31/20,Last post 02/03/20I am using a join to get information from other smartsheet files; I activated the percentage icon and nothing happens and the other fields with regular numbers also lost the original format; if there is no directly solution, I was thinking…Using Smartsheet121NSanchez90676 -
Alert "Worksheet Title"Answered QuestionFirst post 01/31/20,Last post 02/04/20Is it possible to exclude the Title name of the Sheet from a workflow automated email alert? I have multiple sheets shared across with multiple different users. These users are only to enter their stats by the Report and not directly withi…Using Smartsheet241Frank Vue
-
Publish Smartsheet with Filter AppliedAnswered QuestionFirst post 01/31/20,Last post 02/03/20I have a smartsheet with projects with various statuses. I would like to publish this sheet with a specific filter applied to it. When I publish it no filters are applied. Any help would be appreciated.Using Smartsheet472Lawrence Baier
-
First post 01/31/20,Last post 02/01/20Hello, Is there a limit per sheet on the amount of cells that formulas are applied? I know there are other limits, like cell linking and the amount of rows on a sheet (5000). But as far as formulas?Using Smartsheet141Jennifer Workman
-
How do I change ownership of a Dynamic View?Answered QuestionFirst post 01/31/20,Last post 02/09/20Hello - Getting ready to hand the project to the final user and finding out that even though user is added as an Admin in a few Dynamic Views he still cannot edit them (The Settings option is not even available to him) https://us.v-cdn.net…Using Smartsheet393Silvia Rangel
-
Automation emails not sending?Answered QuestionFirst post 01/31/20,Last post 02/01/20I"ve created an automation that I was expecting to send an email w/ form to folks -- but it's not sending to folks. I see it in under my notifications but not via email. https://us.v-cdn.net/6031209/uploads/823/S1KUHFYM6QOY.pngUsing Smartsheet291Shawn Borror
-
Resource ManagementAnswered QuestionFirst post 01/31/20,Last post 02/03/20If I have a taks that is going to take 300 hours to do and I have two resources available to each work 40 hours a week, and I enter a start datem how do I get smartsheet to automatically update the end date based on the 300 hours estimated…Using Smartsheet221BESP10 -
Dashboard/ Report "Current User" Not UpdatingAnswered QuestionFirst post 01/31/20,Last post 02/03/20Seem to have an issue with the Dashboard I just created not updating appropriately. I have a report reading various project information from a sheet. With said report, I have the condition set to filter based on "Current User", w…Using Smartsheet281Curry Cates
-
Attachments Disappear in Sheet Requires RefreshAnswered QuestionFirst post 01/31/20,Last post 02/01/20Hi, We noticed "Attachments" in a sheet tend not to appear intermittently without any rhyme or reason. When it does occur, a simple refresh corrects the issue. Sheet is shared among three teams, any team member may go without see…Using Smartsheet241William Pineda
-
Email Attachment link only valid for 14 daysAnswered QuestionFirst post 01/31/20,Last post 02/03/20I have read that attachment links should be valid for 30 days, but our email links to attachments expire after 14 days. Is there a setting to extend this to 30 days?Using Smartsheet293Curtis Fehr
-
First post 01/31/20,Last post 01/31/20A co-worker of mine is trying to link the text boxes in a dashboard to other sheets. I know its possible to link to the words in the text box, yet you cannot link to the title of the box. So I'm curious if there's a work around for the tit…Using Smartsheet157Hunter Gade
-
First post 01/31/20,Last post 02/03/20As part of the Smartsheet roll out at our company, we 'assigned' our paid license employees several Center of Excellence Training Modules/Courses with different dates to get them completed. I am the Sys Admin and trying to verify who has…Using Smartsheet372sdonnelly -
Count Ifs ANDAnswered QuestionFirst post 01/31/20,Last post 01/31/20Im trying to do a count that captures criteria where both the Status is makred as closed and the TEA Jurisdiction is marked as yes. =COUNTIF(AND([Status]:[Status], "Closed", [TEA Jurisdiction]:[TEA Jurisdiction], "yes"…Using Smartsheet301lesmickin
-
Calendar View Font SizeAccepted AnswerAccepted Answer Shawn Borror 18 views 1 comment 0 points Most recent by Andrée Starå Using SmartsheetFirst post 01/31/20,Last post 02/02/20Hello - is there a way to change my calendar view font size? I'm just trying to put a basic timeline view of a process but the font is tiny making it challenging to read. https://us.v-cdn.net/6031209/uploads/866/L2VBB6M17NZ8.pngUsing Smartsheet181Shawn Borror
-
Dashboard View of Report with Gantt - Not opening to "Current Date"Answered QuestionFirst post 01/31/20,Last post 02/03/20I have noticed that when I post a report to a dashboard in gantt view, the report will display historical dates, even though I have selected open to today's date. The function works properly if I open the report, but the display on the da…Using Smartsheet241Brian_Vaughan
-
Resending a Row with attachmentsAccepted AnswerAccepted Answer lauren.waters111676 28 views 11 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 01/30/20,Last post 02/03/20I have an automation set up to send an "update"/"notify" a specific person when a new row is added. I didn't select any advanced options. We didn't want him notified EVERY time a small change is made to a row, but ther…Using Smartsheet2811lauren.waters111676
-
First post 01/30/20,Last post 02/02/20I have created a template to use in opening customer based Sheets. I would like to add a shortcut to that template on my Portal. The template doesn't appear as a Smartsheet item (like other sheets, for instance), nor does it appear to have…Using Smartsheet111Bradley Berneche
-
Date Created System ColumnsAccepted AnswerAccepted Answer Brittany Flesher 42 views 2 comments 0 points Most recent by Brittany Flesher Using SmartsheetFirst post 01/30/20,Last post 02/03/20Hello! I'm in need of some help with something that seems so simple but I'm going in circles. I was using a form / sheet to track responses for a program that runs quarterly. Standing up a new form / sheet quarterly was becoming an issue s…Using Smartsheet422Brittany Flesher -
Why doesn't the Multi Select Drodown work properly?Answered QuestionFirst post 01/30/20,Last post 01/30/20I selected the multi select dropdown option and it allowed me to enter multiple values in one column, and then few minutes later, when I left click on the list's arrow, it wouldn't work at all, and it would only allow me to enter one value…Using Smartsheet231Al Alanqar
-
First post 01/30/20,Last post 01/30/20When a new row is added to a sheet, can perimeters be set for it to automatically sort its row location based on column info(ie. date, detailer, job). Basically how the "sort rows" function works, but automatically. https://us.v-…Using Smartsheet151Craig Maloney
-
Linking Sharepoint to SmartsheetAnswered QuestionFirst post 01/30/20,Last post 02/03/20Is there a way to link a cell from Sharepoint into a Smartsheet form? Currently my dept. keeps a lot of numbers in Sharepoint. When they update certain numbers, it would be easiest if it could automatically be linked into Smartsheet as wel…Using Smartsheet151Kasey Turnage
-
Gantt VIew in DashboardAccepted AnswerAccepted Answer Shawn Borror 26 views 5 comments 0 points Most recent by Paul Newcome Using SmartsheetFirst post 01/30/20,Last post 01/31/20I'm trying to show Portfolio level timeline - so I've created a report and in that report I have start date/end dates and desired start date for the projects in the pipeline. However my Gantt view does not include the full timeline from st…Using Smartsheet265Shawn Borror
-
First post 01/30/20,Last post 03/08/20How do I get someone from Smartsheet IT support to contact me? I received a trial version of the Jira plug-in but having issues get it connected and have been trying to contact support for 2 weeks now. I've created a support ticket, emaile…Using Smartsheet332kimberlee.adam89166
-
Accepted Answer Jessica Perkins 14 views 1 comment 0 points Most recent by Andrée Starå Using SmartsheetFirst post 01/30/20,Last post 01/30/20Is there a way to stop user from requesting to be a licenses user? Other than telling them to stop asking? I have a new role with two new groups reporting to me. I created a calendar for them to view and edit. All of them have requeste…Using Smartsheet141Jessica Perkins
-
Copy Row IssueAnswered QuestionAnswered [email protected] 33 views 4 comments 0 points Most recent by Paul Newcome Using SmartsheetFirst post 01/30/20,Last post 01/30/20Just had an issue where my copy to workflow only worked on 2 rows out of ~15. This is not a new workflow, and has been tested and functional over 30 times, and no one has accessed or changed anything in the sheet other than me. Is anyone e…Using Smartsheet334[email protected]
-
CREATING INTERACTIVE FORMS / DASHBOARDSAnswered QuestionFirst post 01/30/20,Last post 01/30/20Hi everyone I have developed forms for collecting data remotely. and dashboards for publishing the data..fairly straightforward. What I would like to do is to create an interactive form/dashboard that accesses the information in the sheet.…Using Smartsheet151Glen L
-
Line Graph for Team Member's % Capacity over TimeAnswered QuestionFirst post 01/30/20,Last post 01/30/20This discussion was created from comments split from: Line chart with multiple date-numbers traces.Using Smartsheet142System -
Transferring ownership of a workspace to clientAccepted AnswerAccepted Answer Amit Wadhwani 16 views 1 comment 0 points Most recent by Andrée Starå Using SmartsheetFirst post 01/30/20,Last post 01/30/20Hi, I have a created a work space with customisation sheets for a client, but now I want to completely transfer that workspace to my client. How do I do that? without having him saving sheet as new? it should be the same sheet, just need t…Using Smartsheet161Amit Wadhwani
