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
-
Help with formula to count BLANKS in Assignee field across multiple children rowsIn Archived 2016 PostsHi 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, "…
-
FEATURE REQUEST: Row coloring moves between views.In Archived 2016 PostsI 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…
-
How do I convert Text (from a count) to a number?In Archived 2016 PostsFigured 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 …
-
Formula Bar Blocking BoxesIn Archived 2016 PostsI'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…
-
Formulas looking up data from other sheetsIn Archived 2016 PostsIs 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…
-
Insert Image Into Report CellIn Archived 2016 PostsNow 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?
-
Best time tracking software for Smartsheet?In Archived 2016 PostsDoes 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 …
-
Conditional actionsIn Archived 2016 PostsIs there a way to make it so that when status is marked complete the row automatically moves to another designated sheet?
-
Adding a new currencyIn Archived 2016 PostsHey, 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!
-
Smartsheet Merge issue when using Combine-into-one-file optionIn Archived 2016 PostsWhen 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…