-
Smartsheets Sending Mobile App Notification, but Not Email
I have a conditional alert set up in my form to send an email every time a row is added. When I use a form to add a row, it sends me a notification on my phone through the app, but it isn't sending me an email. I checked my spam filters and there is nothing in there being held. Has anyone else had this issue? This form is…
-
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."…
-
"Persistent", one-time date function
I'd like to see a function like "TODAY()", or cell behavior that supports it, that executes only once when an event is triggered so that the date result that never changes. My use case is a Card view Kanban board with status states: Ready, Dev, Test, Deploy, Done, and matching columns for their start dates, e.g. Dev Start.…
-
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…
-
API CSV import to active SmartSheet
Hello, I have written a program that utilizes the API from smartsheets; for simplicity, it just takes data from a source and imports it to SmartSheets. Problem is, it can only import it on a new sheet, not an active sheet. I understand that there is a tool that was recently developed: Data…
-
Smartsheet Maintenance
What is the Smartsheet maintenance plan? How often do they do maintenance? Do we have the option to not select the updates?
-
New format wastes both time and space
I am very frustrated with the new format. Previously, every single sheet I had open was accessible with a single click, plus I was able to use the entire width of the screen for each sheet. Now, in order to us the entire width of the screen for each sheet, it requires triple the amount of clicks to change sheets: One to…
-
Tabs are moved as a sidebar
My toolbar/tabs/sheet were moved to the sidebar instead of being located at the top . How can I move it back? I can't seem to find the setting.
-
Count Cells That Have Dates Older Than XX Days
I tried a few different formulas for this, but pretty much I have a cell on a separate Data sheet that I want to keep a running count of "Open Work Orders Older Than 0 Days" I tried this (IT Tickets Range 4 is the column with the dates in it) and it keeps giving me "0" for an answer =COUNTIFS({IT Tickets Range 4}, TODAY()…
