-
Help with formula to count BLANKS in Assignee field across multiple children rows
Hi 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, "") will count blanks but how do I get the formula to only count the rows in that range if they…
-
FEATURE REQUEST: Row coloring moves between views.
I 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 color show up on the calendar view.
-
How do I convert Text (from a count) to a number?
Figured 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 and I cannot sum them. Any suggestions how to convert? Thanks
-
Formula Bar Blocking Boxes
I'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 make it so I can still see/click the boxes behind it? Thanks!
-
Formulas looking up data from other sheets
Is 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 wondering if Smartsheet also allows for this.
-
Insert Image Into Report Cell
Now 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?
Does 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 my Smartsheet spreadsheet or Smartsheet Sight as a one stop shop with various other…
-
Conditional actions
Is there a way to make it so that when status is marked complete the row automatically moves to another designated sheet?
-
Adding a new currency
Hey, 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 option
When 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 not displayed in the combined file per page; when I use the merge print on single pages,…