Using Smartsheet
Archives for April 2018
Discussion List
-
First post 04/30/18,Last post 06/07/19I currently have a form sending data to a sheet, and then data from that first row displaying on a dashboard that I can print out for a visual representation of project data. Is there anyway that I can choose which row of data I want to sh…Using Smartsheet3848oberning -
First post 04/30/18,Last post 05/01/18Hi Everyone Just trying to figure out why I can't choose myself for a dropdown menu list. The error reads "Please enter or select a contact from the dropdown list. A sheet admin has restricted this column to dropdown contact…Using Smartsheet131Hai N
-
First post 04/30/18,Last post 09/06/19Is the ability to select multiple items from a dropdown still in development???Using Smartsheet293mark.gipson27746
-
First post 04/30/18,Last post 04/30/18Is there a way to print multiple card views (same as the print from row function)?Using Smartsheet171james lonergan
-
First post 04/30/18,Last post 04/30/18I am trying to make a sheet and a form that will allow me to notify different people from different departments to make sure they get the correct information. Can this be done and if so how. Please let me knowUsing Smartsheet15justin46491
-
First post 04/30/18,Last post 05/02/18I recently noticed that all dates including columns that are hidden are showing with my automated reminders. I have a number of calculated dates that I don't want to display. However, all of them now show on the reminders. This is a fai…Using Smartsheet45Jerry Tutt -
First post 04/30/18,Last post 04/30/18Hello, I right click on the rows at the bottom of my sheet and delete but they keep reappearing. I'm fine with say three but there about 12. These also are printed. can you help?Using Smartsheet611Maggie Young
-
First post 04/30/18,Last post 05/01/18Good Morning, I am struggling with presenting a project roll up including gant in a clean view. I would say a program view is what I was wondering if anyone had some guidance on. Thank you. LynnUsing Smartsheet241LSULLi00820
-
First post 04/29/18,Last post 04/30/18Dear All, As mentioned I am trying to cell link the Task and the start date. Post to creating the cell link I add a predecessor to the line,however the link to the Start Date disappears? Could someone please help me with this as this is c…Using Smartsheet12Taru
-
First post 04/29/18,Last post 04/30/18Hello all, I have been using smartsheet for about a year and I am all in. As Nerdy as this may sound, I enjoy using smartsheet to create solutions, as I have done, still doing, for my insurance agency. I would enjoy having a business, …Using Smartsheet231shahn.sria46436
-
First post 04/27/18,Last post 04/27/18I'm new to SmartsSheet and don't see an obvious way to track time, and have it recorded against a task Personally not too fond of % complete - to often I've seen people say/think (legit or not) that they're 90% done, and the last 10% take…Using Smartsheet112tcgibson46341
-
First post 04/27/18,Last post 04/27/18Hi all - I am working on a variance formula to first.. if error make a blank... and then to secondly... calculate the number of working days between to dates. I need the variance of our "planned end" and "actual end" co…Using Smartsheet805Bri Boyer
-
First post 04/27/18,Last post 05/11/18hello all, my percentages are going int minus or over 100% . i currently use this formula , can anyone help =(TODAY() - [Start Date]5) / ([End Date]5 - [Start Date]5) regards Carl (Image)Using Smartsheet178gabsy1972 -
First post 04/27/18,Last post 04/30/18I want to create something that is several columns containing data is is continually updated - but only added to, no content is ever deleted. I'm calling this the "template". I'd like to be able to pull the "template data&qu…Using Smartsheet491nickmerge
-
First post 04/26/18,Last post 06/11/18Hi All, I am trying to change the today condition in this formula to today - 2 in order to become red few days before but it's not working. Does someone know how I could do it? =IF(AND(Finish78 < TODAY(), [% Complete]78 < 1), &…Using Smartsheet13Nathiele
-
First post 04/26/18,Last post 08/13/19I am trying to find a way to use the DONE checkbox to then notify the dependent task assignment that it is ready to launch. I have looked for solutions and come up with the idea of having a handoff column, but then that is just putting th…Using Smartsheet132blairfarley
-
First post 04/26/18,Last post 04/26/18Got a rookie question... I'm using the system-generated creation date/time. Time zone recorded looks to be correct (EDT). I have a report that displays the time correctly. That report is included in a dash board that also looks correct…Using Smartsheet21john.spikula42751
-
First post 04/26/18,Last post 04/27/18Has anyone had any success creating a chart with nonadjacent columns following the recent communication that the charts have more options?Using Smartsheet154Tim
-
First post 04/26/18,Last post 01/29/19Can anyone advise. I have typed a paragraph into a cell and applied wrap text but I still only see a quarter of what I typed. thank you.Using Smartsheet1537Maggie Young
-
First post 04/26/18,Last post 04/27/18Is there any enhancements on the way to make the report dashboards more configurable. Risk Log - highlight report doesn't show the mitigation & when there too much text in a box goes off the page, is there something that can be done?…Using Smartsheet161Lifestyle PMO
-
First post 04/25/18,Last post 04/26/18Hi Their i have a card view where i want my staff to enter in certain information, i want to be able to add some cells with some formulas that DO NOT appear on the card view but are viewable or present in the grid view. for example i hav…Using Smartsheet881mikenz1983
-
First post 04/25/18,Last post 01/22/20Any one know if we can set auto email comments, instead of manually email comment? Thanks in advanced! (Image)Using Smartsheet18113Vaynard
-
First post 04/25/18,Last post 07/27/18Some of my admins of certain sheets cannot send rows to other sheets that they are also admins of. Anyone else have this problem? (yesterday it was working)Using Smartsheet112Nik Lutz
-
First post 04/25/18,Last post 04/25/18I am looking to use a form to make multiple entries into a sheet without the form going away once I hit submit, e.g., I should be able to fill an entire spreadsheet of tasks from one form. Thanks D AUsing Smartsheet12dana46031
-
First post 04/25/18,Last post 04/25/18I am looking to set up a notification once everything in a specific column has been check marked. Basically I have 10 things that need to be collected by someone every week, they are listed in rows in the sheet and have a checkbox next to…Using Smartsheet341bradley_B
-
First post 04/25/18,Last post 04/26/18A client filled out a form and said it would not submit. She checked all her info and it still would not submit. I tried it once with an upload and once without and it worked and had one other person check it and it was fine. Anyone ever…Using Smartsheet1192lorierion
-
First post 04/25/18,Last post 07/09/19I have a "closed" check box in my sheet. Based on that being checked, I want to automatically fill a closed date in another column. Not sure how to do that. Help! ThanksUsing Smartsheet2637lhammond
-
First post 04/25/18,Last post 04/26/18Id like to summarize status for a list of users involved on multiple project checklist. The dashboard function tells me I can only use numerical data in reports/widgets. Is there something I am missing? I want to provide a quick glance at …Using Smartsheet21ggordon1
-
First post 04/25/18,Last post 04/25/18I have a huge data set and that need to be filtered owner-wise in my bar/pie chart. However, I do not see any filter option available. Please help me if someone is aware of this.Using Smartsheet1311vramesh
-
First post 04/24/18,Last post 04/26/18Hi Everyone, I have been trying to get my RYGB to automate based on the tasks dates. I would like from the start date to 8 days to be Green...More than 10 days from start to be Yellow and the last 5 days before the end to be Red. I hav…Using Smartsheet166jbusch30