-
Am I the only one who does not like the new December 2018 look?
I'm struggling with the new layout and welcome any suggestions. I do not have the dashboard level subscription - just below that, I think. I HATE that I have lost my tabs, and I hate that the menu button ALWAYS takes me back to the RECENTLY VIEWED as opposed to the Home. This new layout just seems like more work to manage…
-
Loss of Tabs
Can someone please explain to me the reason for removing the sheet tabs and changing it to what we currently have now? I understand changes that are less user-friendly up front if they provide an overall better experience or increases the functionality and capabilities of a program. However, in this case I see absolutely…
-
Filter counts after revised UI
Since the UI change was rolled out over the past week, we no longer have the same filtering functionality as before. One of the options that we utilized when using a filter, was the counts that were available. Such as when you applied a filter, it would inform you that there were 23 rows of 40 showing. We utilized this…
-
Auto-Populating One Sheet Based on Criteria of Another
I have a contact form that once the contact proceeds into the opportunity phase (think CRM), I want to automatically have their info populate into another sheet. In the contact sheet, I envision a column titled "Proceed to Opportunity" with two options of Yes or No. If no, they stay as a contact. If Yes is selected, their…
-
Identifying and returning phrases within a single cell
Hi all, I have been trying to figure it out alone but I thought I'd engage the community to see if anyone can help! I have a column in my spreadsheet that contains phrases separated by commas - for example (though with different words), in one cell it says "Phone, computer, mouse, cell phone, water bottle, earphones, bag."…
-
Data Validation
How can we validate data at cell level? I want different cell ranges (in the same column) give me different drop-down options. Right now I see that we can validate data at column level and not at cell level while Google Sheets and Excel allow validating data at the cell level. Please suggest should I do? Thanks!
-
VLOOKUP for attachment on another sheet
Smart sheet enables the user to upload attachments, which is useful. So what I do for my workflow is I have a full sheet dedicated for part number and part information, so when I type in a part number on the work order sheet it auto-fills the rest of the information such as description, assigned person etc using the…
-
auto-numbering Created (Date) grayed out
I am trying to have my sheet keep track of new entries created using my form. I found that I could use Auto-Numbering and select Created (Date), by looking through the forums here. However, when I try to change the properties of my form, the Create (Date) option is grayed out. Can someone explain what might be going on?
-
After Reducing Cross-Sheet References
Hello, I hit my maximum cross sheet reference of 25000 - I removed a SUBSTANTIAL amount of columns that were pulling useless information (we realized we didn't really as much information like we thought we did.) But - since removing a high quantity of cell links, my sheet is still not calculate the remaining…
-
Keeping persistent dates for status changes
Building a kanban board with typical IT cycle states: Ready, Dev, Test, Deploy, Done. I'd like to track cycle times and throughput. I've created (locked) columns to capture a status change for each of the cycle states; e.g. Dev Start and formula "=IF(Status@row = "Dev", TODAY())". That works to capture the date that a task…
