-
Filter on columns with values populated by a formula
Hello. After searching and coming up empty handed, I decided to post for help. I have columns in a sheet that are populated by VLOOKUP functions. Whenever I run a filter on one of those columns, all 1703 rows of my sheet are in included or excluded. As an example, if I set a filter on the "Effective Price To" = "is not in…
-
Countif, isdate, weeknumber
Hello, I'm trying to write a formula that will count rows containing a date that is part of the current work week. The date column has non date values in a few cells which seems to be throwing off my formula. This is what I have so far; =Countif([Due Date]:[Due Date], AND(isdate(@cell),…
-
Adding New Rows
Hi, When adding a new row, I cant figure out the rule for indenting. Sometimes it will be correctly indented the same as the row above it. Sometimes it will add new row as a "Parent" and then automatically make everything below it the "Children" Is this caused by the way I'm inserting, or is there a default setting to make…
-
Populating Sheet Column Content from Report
We are using a unified Asset Tracking sheet in smartsheets for multiple types of Equipment (i.e. Phone, Computer, Printer, etc...). This sheet has basic Asset Tracking information in it but we need to gather additional equipment specific to each type of equipment as well. We could create a column for each in the Unified…
-
Saving Indented Row View
I love the Indent feature and especially the CHILDREN() function. Every time I save sheet or switch back from another sheet, my hidden indented rows completely expand & I have to re-click everything to find where I am. What am I missing to make sure the rows stay hidden until I need them? Thanks INB
-
hh:mm:ss Time Tracking in Smartsheets? (Probably not possible)
Howdy everyone! I've got a pernicious little problem that I'm wondering if anyone has any ideas about. My team and I currently track all of our break/fix help tickets in one dedicated "backlog" sheet. Each task that we need to complete is added to this sheet, gets prioritized, gets worked on, gets clarified (if needed),…
-
Feature request: copy a "column" (column name, formatting, configuration, etc) from one sheet to mul
Feature request: If I create a column with a specific name, configuration, formatting, etc - it would be nice to be able to copy that column over to another sheet - or better yet, to multiple sheets. Or - an ability to "link" multiple sheets together, based on a specific template, and if you make a change to the "template…
-
Unrecognized or Invalid Emails??
When sharing sheets between My account and Others(business partners/clients), I often run into unrecognized email accounts warnings/alerts... (and I have to drop what I'm doing and setup a contact in "My Smartsheet Contacts"). Wondering how common of a need this might be. I might invest a bit of time to come up with a…
-
Cell References
I'm trying to reference a sheet using a cell value, but it doesn't seem to be working. Is it possible? Cell Value: "Test Sheet" I want to reference different rows based on the first cell value, basically retrieving different cells from that one "Test Sheet" -- the reason why I want to do that is so I can just copy/paste…
-
Cell level independence (type)
Hi, Will we see a cell level independence concept soon in SmartSheet ? Currently, we can defined entire row functions and column types but cells are bound by these row and column settings (can't be overwritten) Ex: An entire row can be commented on but no a specific cell. What if we have a column specific data set and want…
