-
New UI 12-14-2018
This UI is terrible, I don't even want to waste my time explaining why at this point, it is OBVIOUS. At this time I am contemplating updating all training materials, SOP's and videos or just throwing in the towel and searching for a replacement. I simply do not have the time to re-learn, re-document, re-train every time…
-
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…
-
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."…
-
Nested IF(ISBLANK & Date Columns w/Progress Bar
Hi Everyone! I would like to know if you are able to use date columns when automating a progress bar. Basically dates are entered as product moves to a new stage in the process. As the dates fill in, the progress bar fills as well. I've used nested IF formulas for automating a progress bar but, for whatever reason... Im…
-
Current Task Formula based off certain criteria (symbols)
Hi, I want to create a formula that would read all rows have a Green symbol and read back the last task name that has green. This would have to be based off the row number and not dates, given not every task will have a start or end date. Attachment for context --> I would want the formula to read all of those tasks and…
-
Search and Replace, Conditional Formatting
I have multiple columns with a variety of drop-downs on many sheets. Conditional formatting is set to many of the columns based on the drop down selection, sometimes up to 40 statements. The problem I'm faced with is if I change one of the drop down selections (abbreviate a selection for example) that is currently being…
-
COUNTIF Formula for when a cell contains a specific word/phrase?
I'm trying to create a formula that allows me to count the number of times the word "Postcard", for example, appears in a list in a column. I am referencing a column in another sheet to do so. However, nothing I've tried works. My instinct was to try =COUNTIF({2018 Open Enrollment Feedback Range 1}, "Postcard"). However,…
-
Paste raw data into Filters
I love the Filter for "Show rows that match" is one of "select values". I however would love to be able to paste from NotePad, Excel, an email, etc a list of values separated by line or comma (IE: 5045,5046,5097,6014,5058) to automatically have that select instead of having to scroll down to select the 50 lines I want…
-
Turn off Auto-Save on Android App
Is it possible to turn the auto-save function on the Smartsheet Android app 'off'? When our guys use the app on their tablets when they have a weak connection, after each cell there is a long wait untill it has saved. is it possible to turn this off, and maybe just save it when required, or when you leave the sheet or…
