-
How to use Forms for populating Sheets
I have bunch of demo units that are used by sales people. I want to use Forms to automatically populate a sheet with a customer name, the desired start date of a demo and the planned end date. Subsequently, I want to use Form to release the use of the demo unit (i.e., make it available for others to use it) as well as…
-
If project status complete - stop calculating formulas & Conditional Formatting
Greetings, Currently at row 1600, waiting for a cell's formula to process the formula may take up to 10 minutes. For instance, sometimes when I change the duration of a Child row by 1 day, it may take 10 minutes for the End Date to advance by 1 day. I use A LOT of formulas, cross-sheet references, as well as Conditional…
-
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…