Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Archived 2016 Posts
Archives for April 2016
Discussion List
-
First post 04/30/16,Last post 05/02/16Hi all, I'd like to count only the rows below where the Assignee field is BLANK. The problem is my formula is counting the parent rows (ECS Inbound, ECS Outbound, Flat File Inbound). I know that =COUNTIF(Assignee28:Assignee60, "…Archived 2016 Posts31Dennis S. -
First post 04/29/16,Last post 05/02/16I have a feature request. It would be extremely helpful to have the row background color move between the different views (grid, calendar, etc.). When I have color coded a particular row in the grid view, I would like to have that same col…Archived 2016 Posts21Jenn
-
First post 04/29/16,Last post 04/29/16Figured out how to use the COUNTIF to get a count within a column if a box is checked it contains a certain text in a dropdown, by changing the results to text (e.g., ...+""). However, what appear to be numbers are acutally text …Archived 2016 Posts1341Elaine Wright
-
First post 04/29/16,Last post 11/26/17I'm sure this is an easy one, but when I'm adding a bunch of math in a specific field, it eventually blocks the entire row. I then can't choose boxes within the row that will be nested in the equation. Any way to hide the formula or m…Archived 2016 Posts553Bob Lee
-
First post 04/29/16,Last post 06/30/17Is it possible to create a formula in one sheet that looks up info from another sheet? I dont mean linking cells - I need to be able to set an IF statement based on the input of one column in another sheet. You can do this in excel so im…Archived 2016 Posts42Cyvia Star
-
First post 04/29/16,Last post 07/30/19Now that it is possible to insert an image directly into a Sheet cell, can this functionality be extended to a Report, so that the image gets inserted onto the underlying Sheet cell?Archived 2016 Posts552Jorge Castilla
-
First post 04/29/16,Last post 08/14/18Does anybody know of a good time tracking software that I can integrate with Smartsheet? Specifically, I am invisioning using a third-party time tracking software and be able to link the information (i.e. billing to date, hours, etc.) to …Archived 2016 Posts32Erik Mayo
-
First post 04/29/16,Last post 04/29/16Is there a way to make it so that when status is marked complete the row automatically moves to another designated sheet?Archived 2016 Posts41Clayton Neighbors
-
Closed Pedro Assuncao Soares 71 views 4 comments 0 points Most recent by Emmanuel DELARUE Archived 2016 PostsFirst post 04/29/16,Last post 06/29/19Hey, My company is use to work with Central African Francs (XAF) as default currency. At the currency list in the spreedsheet, we do not have it. Does anyone know how to add a currency? Thanks in advance!Archived 2016 Posts714Pedro Assuncao Soares
-
First post 04/29/16,Last post 04/12/17When I attempt to use the combine into one file option, such as when I'm using a 1-page Google document template to print five (5) rows into 5 pages, the combined file output exhibits the following errors: 1. Contents in the header are no…Archived 2016 Posts305DanS -
First post 04/28/16,Last post 04/29/16Only a couple of days into the trial and I was looking at creating some KPI's for a Sight. Based on what I'm seeing, the underlying calculation MUST exist on a sheet somewhere to be pulled into a sight. The problem I run into is if on …Archived 2016 Posts24Dennis S.
-
First post 04/28/16,Last post 04/29/16Hello All, Our IT Department does not like that any registered user of smartsheets can access the web request if the have the url. The solution would be a username and password authentication to allow access to the Web Request that allows…Archived 2016 Posts461meyersoundmw
-
Closed Gregory Scharfstein 270 views 5 comments 0 points Most recent by Shaine Greenwood Archived 2016 PostsFirst post 04/28/16,Last post 02/27/19Smartsheet, It would be nice to be able to change the color of a parent task bar in the Gantt Chart. What is the reason for not being able to do this? I did find a comment (https://community.smartsheet.com/discussion/cannot-for…Archived 2016 Posts2705Gregory Scharfstein -
First post 04/28/16,Last post 04/28/16Hi guys, I want to know the percentage complete for my project. I have 10 tasks below my parent. If 3 of the tasks are checked, I want the parent to say 30% completed. I am using the formula below to find out how many of the boxes are c…Archived 2016 Posts4472mclarenfan
-
Closed Gregory Scharfstein 53 views 9 comments 0 points Most recent by Lachlan Stead Archived 2016 PostsFirst post 04/28/16,Last post 07/15/18Smartsheet, In the Discussion feature, I find myself needing to write a comment - then click SAVE - then click on the "Email Comment" button - then fill out the person's (or people's) names in the discussion and then click se…Archived 2016 Posts539Gregory Scharfstein
-
First post 04/28/16,Last post 04/29/16Non Global addministartors are unable to Connect to Office 365 via the Outlook App. All users here have logon access to the O365 portal. Othe Outlook apps we are using login with now issues. Users are getting a pop screen stating -----…Archived 2016 Posts491Rick Martin
-
Closed Jessica Hitt-Laustsen 27 views 1 comment 0 points Most recent by Archie Lopez Archived 2016 PostsFirst post 04/28/16,Last post 04/28/16Hello, I recently became a curriculum manager and want to utilize Smartsheet to oversee the annual curriculum, the coordinators, and take on a project management role. Has anyone used smartsheet in a similar way and if so, do you have an …Archived 2016 Posts271Jessica Hitt-Laustsen
-
First post 04/28/16,Last post 05/01/16I want to have a sheet where based on a condition like a checked box certain rows are or are not available. For example if CAPEX is not checked then the Capex task rows are not available to see. Is this possibleArchived 2016 Posts622Ed19
-
First post 04/28/16,Last post 07/12/18Hi, I'm trying to create a report based on a sheet I'm an admin on, but it's coming up blank. I build the report based on that sheet, so all the column match. If I select a different sheet it works & shows all the information. I…Archived 2016 Posts378Mel G
-
Closed Aric Edwards 143 views 5 comments 0 points Most recent by Shaine Greenwood Archived 2016 PostsFirst post 04/28/16,Last post 08/02/17Hello! Originally, Smartsheet was set up as a HIPAA compliant item. Can anyone clarify when this changed and what justification caused this change? I have reached out to Smartsheet but they haven't gotten any feedback. Does anyone else…Archived 2016 Posts1435Aric Edwards
-
Closed Brandon Tarver 16 views 5 comments 0 points Most recent by J. Craig Williams Archived 2016 PostsFirst post 04/28/16,Last post 04/29/16I've got a long formula that determines an IP address for a computer. That formula should result in a formula for an IP address that looks like this: 10.20.12.32 However, when there's a zero entry, SmartSheet is omitting the zero,…Archived 2016 Posts165Brandon Tarver
-
First post 04/28/16,Last post 04/28/16I'm sure what I'm looking to do is not that difficult, I just can't find a way to achieve it. What I have is a sheet that consists of quote amounts ($) that are relative to a quote date. What I want to do is to look at how many dollars we …Archived 2016 Posts581ll00ll00ll
-
First post 04/28/16,Last post 04/28/16Hello I have a task made up of multiple intervals, can smartsheet include these in the tasks/gannt? Example - task 'a' - start 28/4, finish 29/4, start (1) 2/5, finish (1) 4/5, start (2) 6/5, finish (2) 13/5 Thanks Alan …Archived 2016 Posts272Alan Russell
-
First post 04/28/16,Last post 10/17/18i'm 2 hours into this experiment so please pardon my ignorance. I'd like to create distinct dropdown lists for different rows in a worksheet. So the column header is "Color" and the first row is for "Paper" and I have…Archived 2016 Posts1285Bill McMaster
-
First post 04/27/16,Last post 04/29/16(Image)Archived 2016 Posts242Mario K M
-
Closed Alex Chapin 24 views 13 comments 0 points Most recent by Shaine Greenwood Archived 2016 PostsFirst post 04/27/16,Last post 02/06/18Please add one or more of the following functions: switch, vlookup, and/or lookup. Note that this would make it easier to reference rate categories in a rate table without having to use a huge nested if function.Archived 2016 Posts2413Alex Chapin
-
First post 04/27/16,Last post 04/29/16I like the new look to the Support Center. https://community.smartsheet.com/support Easier to navigate. Well done. CraigArchived 2016 Posts31J. Craig Williams -
First post 04/27/16,Last post 04/27/16Hello all, I have a sheet shared with 7 people. Almost everytime I save there are multiple rows that are randomly shuffled into different spots on the sheet. I have no formulas or macros... I thought I would throw this out to the…Archived 2016 Posts253Trevor Walker
-
First post 04/27/16,Last post 09/26/19Is there a way to link a whole column to another sheet? I need a whole column linked, not just cells. Copy and pasting 500 cells at a time is not going to work, as it will not update if rows are added or deleted. I considered a report, …Archived 2016 Posts164010Craig Duffy
-
First post 04/27/16,Last post 11/01/18I feel silly asking such a basic question, but it's got me stumped. Normally, under Column Properties, when I select Check Box, a box appears in the column as it should. However, no matter how many times I've tried, no boxes appear. It…Archived 2016 Posts8635Cara Imperato