Recent Discussions
Find answers to Smartsheet questions, learn about project management best practices, discuss the future of work management, and get how-to guidance for every Smartsheet use-case from fellow users and Smartsheet experts.
Discussion List
-
Is there a way to graph cells that don't have valuesAccepted AnswerAccepted Answer jpagan03101416 14 views 2 comments 0 points Most recent by Paul Newcome Using SmartsheetFirst post 03/24/20,Last post 03/24/20I am creating graph that will have values depending on the month, the cells have the Labels(Titles) but aparently blanks or 0 are not values that charts will consider.Using Smartsheet142jpagan03101416 -
Update all rows with dependency defined (Duration and Predecessors)Answered QuestionFirst post 03/15/20,Last post 03/24/20In Smartsheets I have these columns Duration, Predecessors, Start and End Date, When I change my base Start date all my rows for EndDate and StartDate are then populated. I am trying to achieve the same functionality by api but when I upda…API & Developers441Joy Biswas
-
Nested IF Formula for Automating Related ColumnsAnswered QuestionAnswered Danielle Arteaga 13 views 4 comments 0 points Most recent by Danielle Arteaga Formulas and FunctionsFirst post 03/24/20,Last post 03/24/20I have a sheet that has rows added through an automated background process (not a form). As the rows come in, they are assigned a date in a column called "Date of Inquiry." There are two other pertinent columns in the sheet: a H…Formulas and Functions134Danielle Arteaga
-
Can we customize a "published" link? Purchase a custom Domain/ URLAnswered QuestionFirst post 03/23/20,Last post 03/24/20Hello I have a portal for all employees to see current job openings and the link is very LONG. Is there any way to get a smaller customized URL for a published dashboard?Using Smartsheet151Fidencia Brown-Tracy
-
Adding PDF or Hyperlink in FormAnswered QuestionFirst post 03/23/20,Last post 03/24/20Hello, Is there a way to embed a pdf in a form? Or add a hyperlink to the form? I am trying to add the descriptions of the categories on a separate page rather than on the form. i don't want to add the link directly as its pretty long. …Using Smartsheet201Simon Mohamed
-
First post 03/19/20,Last post 03/24/20Hi SmartSheet community! This may be an odd one to describe but I am going to try my best. I have a process that is a bit circular and is also a "maybe situation." For our product, we will go through rounds of optimization but o…Using Smartsheet251Zoe Charalambous
-
Need FormulaAccepted AnswerAccepted Answer Jeremy Klingensmith 23 views 5 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 03/23/20,Last post 03/24/20I need a formula that will raise the flag when the following conditions are met: -If Status reads "Not Started" or "Complete" AND -If Start Date is less than TODAYFormulas and Functions235Jeremy Klingensmith
-
Helper columns vs #UNPARSEABLE errorAccepted AnswerAccepted Answer Stephen Wood 16 views 4 comments 0 points Most recent by Stephen Wood Formulas and FunctionsFirst post 03/24/20,Last post 03/24/20This works for me using helper columns where I do count(parent) and count(children) =IF(OR(children18 = 0, Parent18 > 0), 1, 0) If I substitute the count(children) its #UNPARSEABLE =IF(OR(count(children) = 0, Parent18 > 0), 1, 0)Formulas and Functions164Stephen Wood -
Add contacts to a cellAnswered QuestionFirst post 03/24/20,Last post 03/24/20Any ideas or workarounds to add several contacts on a sheet to a cell in another sheet? I need to send an alert to the project team. I've shared the sheet with the project team but also with alot of other people who don't need the alert.Using Smartsheet122sbrelage
-
Help with complicated formula 🙋♂️Accepted AnswerAccepted Answer Mark Silvester 14 views 3 comments 0 points Most recent by Paul Newcome Using SmartsheetFirst post 03/23/20,Last post 03/24/20The spreadsheet in question is a shipping/inventory database: https://us.v-cdn.net/6031209/uploads/522/7ME545MJFS1I.png In the screenshot above, the first rows represent the total amount of contracted devices. In this case, the client has …Using Smartsheet143Mark Silvester
-
Time-tracker formulaAnswered QuestionFirst post 03/24/20,Last post 03/24/20Hello, I have a time-tracker and have 2 problems: For some reason the total isn't calculating. It just calculate 1 hour. Here's the fomular i'm using =VLOOKUP([Talent/Materials]1, $Rate$5:$[Talent/Materials]$11, 2, false) * Hours1 When I …Formulas and Functions256Chichi
-
First post 08/23/19,Last post 03/24/20Hi All, I think this feature should be a part of the Smartsheet web client, however, it is not. BUT it is a part of the mobile app. When I go to type someone's name into a contact column field USING A FORM, it won't auto complete and sh…Using Smartsheet513Connor Hartford
-
Send Update RequestsAnswered QuestionFirst post 03/24/20,Last post 03/24/20I deleted an automated "Send Update Requests" that I set up but for some reason it is still sending notifications to people. How can I undo that even tho I can't see where its coming fromFormulas and Functions116Chichi
-
How do I set up a 'running date column'?Answered QuestionAnswered Tiffany Sherrane 11 views 1 comment 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 03/24/20,Last post 03/24/20Similarly to a running total, I am needing to have a running date. So that every day it will move and change based on 'today'-- and referencing my start date column. How do I set this up?Formulas and Functions111Tiffany Sherrane
-
First post 03/24/20,Last post 03/24/20My notifications are not working. Nothing has changed on my end. They have worked for over a year. They stopped working a day or so ago.Using Smartsheet111Gene O'Connell
-
Sum of column YTDAccepted AnswerAccepted Answer Jen Tankersley 15 views 3 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 03/24/20,Last post 03/24/20I am not a pro with formulas, but I have been able to figure out most of the formulas I need by perusing this community. However, this formula comes up #unparseable with everything I do. Can someone help me spot what I'm doing wrong? =SU…Formulas and Functions153Jen Tankersley -
Calculating Fuel ConsumptionAnswered QuestionAnswered Jacques Hollands 32 views 8 comments 0 points Most recent by Rainier Hollands Formulas and FunctionsFirst post 03/23/20,Last post 03/24/20Hi there, I manage a transport fleet and want to use Smartsheet to track the vehicles' fuel consumption. It is calculated by subtracting the kilometres from the previous fill-up from the current fill and dividing this variance by the litre…Formulas and Functions328Jacques Hollands
-
First post 07/30/19,Last post 03/24/20I have created dashboards that include charts, for which I have selected specific colors for each category. Data for the charts come from different sheets. However, everytime I add a new row to the source sheet, I have to update manually t…Using Smartsheet382bruno.benavides
-
How do you expand the height of a row?Answered QuestionFirst post 03/23/20,Last post 03/24/20How do you expand the height of a row?Using Smartsheet163Danny Sax
-
Updating data in existing rowsAccepted AnswerAccepted Answer Robyn Pier 68 views 27 comments 0 points Most recent by Paul Newcome Using SmartsheetFirst post 12/16/19,Last post 03/24/20Hi I need to allow my team to update nursing visit dates on existing patients. I have read that I can't use a form to do so. I can't really use an update request because I don't know when the changes are going to take place. Is there an…Using Smartsheet6827Robyn Pier
-
First post 11/26/18,Last post 03/24/20Someone posted a comment to me and I was notified because he used the @. I hit the reply button on the comment and he was not notified of my reply. In order for notifications to go out - you must use the @? Seems like a reply should tri…Using Smartsheet564allison.bastone24911
-
Rainier Hollands 32 views 4 comments 0 points Most recent by Rainier Hollands Formulas and FunctionsFirst post 03/24/20,Last post 03/24/20Hi guys I need help writing a formula. I'm trying to write a formula in which it calculates the fuel consumption for each truck for that specific date. What I was trying to say with the formula is that it should look at which truck, date a…Formulas and Functions324Rainier Hollands
-
First post 03/23/20,Last post 03/24/20I was trying out DataMesh for the first time and ended up getting the following Error message: Error code: 500! undefined method `[]' for nil:NilClass As it is very non-descriptive, I have absolutely no idea what I did wrong. Has anyone el…Premium Apps and Integrations111JessMK
-
Count if by dateAccepted AnswerAccepted Answer Sean Murphy 15 views 5 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 03/24/20,Last post 03/24/20@Paul Newcome Hey Paul, I'm working on further automating the tracking sheet you've helped me with. My goal is to tally a task completion by date from our plant managers progress sheet, currently I'm just counting and manually adding it to…Formulas and Functions155Sean Murphy
-
Formulas lost when Move/Copy row from one sheet to another?Answered QuestionFirst post 12/17/19,Last post 03/24/20We want to move rows (preferably using Automation) from a source sheet which contains formulas in the rows, without losing the formulas once the row arrives in destination sheet (the sheets are identical in terms of columns). The source sh…Using Smartsheet7914hanseric -
Adding multiple contacts to a contact field with formulaAnswered QuestionAnswered cthrasher97141 53 views 5 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 01/08/20,Last post 03/24/20Hello I would like to add multiple contacts to a single contact cell for one task with a formula, is there a away to do this? Can Group Management be utilized? Thank youFormulas and Functions535cthrasher97141 -
individual format of cells in one columnAccepted AnswerAccepted Answer Jörg Schmidt Novum Hospitality 10 views 5 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 03/24/20,Last post 03/24/20Hallo, I want to compare various offers. Therefore I add three offers in the columns. In the rows you find the different performances. Is it possible to format the various cells in one columns with different formats - one cell with symbol…Using Smartsheet105Jörg Schmidt Novum Hospitality
-
ReportingAccepted AnswerAccepted Answer Usha Pillai 15 views 4 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 03/23/20,Last post 03/24/20Hello, I want to have parent row pulled into my report. I used the following formula from one of the previous threads to automatically check parent row if a subtask is due to start in 30 days. However, the formula does not check parent row…Formulas and Functions154Usha Pillai
-
First post 05/15/19,Last post 03/24/20Hi, I'm new to Smartsheets and am experimenting with the Calendar App add-on. It seems like a great tool, but I'm having difficulty with the legend. When I created my first calendar using the app, there was a legend at the bottom, but now …Premium Apps and Integrations364smayer
-
Calendar App with Parent Child hierarchyAnswered QuestionAnswered Heather O'Shea 24 views 2 comments 0 points Most recent by Francine Haman Premium Apps and IntegrationsFirst post 03/13/20,Last post 03/24/20I am looking for a way to show the parent child relationship within our calendar. For our events, we want to show the event name (parent), then each task (child) so they are sorted and bundled together as they show in the sheet. I am at…Premium Apps and Integrations242Heather O'Shea
