-
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()…
-
Tabs No Longer Showing
Sometime last week I noticed my view in Smartsheet (using Chrome) no longer has the tabs at the top of all of the current open sheets. How can I get this view back? It was much more efficient than the pinning option we have now. Also, the recently reviewed Smartsheets would be great if it actually filled up that column but…
-
Exclusion Formula for Sum/Count
I am trying to get a total of my "Forecasted Amount" column which should include the following stages "0-Lead"+"2 - Qualified"+"3 - Proposal"+ "4 - Final (EL)"+"5 - Win". Currenly I have it set up to only not include the "6 - Lost" with this formula: =SUMIFS(CHILDREN([Forecasted Amount]52), CHILDREN([Referral…
