-
Automate RYG Ball based on Checkboxes in Other Columns
I need help from the SmartSheet formula masters... I have 10 checkbox columns (checkbox) and I want the RYG ball to automatically change with the following conditions: * 1) "Red" if no checkboxes are checked. * 2) "Yellow" if some checkboxes are checked. * 3) "Green" if all checkboxes are checked. with one exception... if…
-
Critical Path not working
The critical path on my schedule is not working, is there a report I can get from smartsheets to see what is porssibly going wrong? or Tips on what to do?? Much Appreciated! -Marisela
-
I cannot manually re-open manually collapsed columns.
I have collapsed a few columns manually by dragging its header row borders but are now unable to open them back up. Even if I use my browser zoom button to precisely select the border the double arrow cursor will only select either column to the left or right of all the manually collapsed columns. I can verify the columns…
-
Webforms | Survey - Customizing Column Headers or Question Content
I currently use an external tool to conduct 200-300 surveys and collect data on project performance for my org annually. Data is exported from the tool and compiled in excel. I want to transition to SmartSheet to alleviate the manual survey creation and lift and shift of data. Problem: Each survey is customized listing a…
-
Formula for a carriage return within a cell
Hello i have this formula for milestones, however I would like to format it so that the "Milestone Count, Milestone Reached, Milestones to Go are all lined up to the left of the cell. I cannot change the size of the cell as there are multiple tasks in that same column. ="Milestone Count. . . . . . . " + COUNT([Notify…
-
More column types?
Any chance we will see additional column formatting to include things like Currency and Phone number formatting?
-
Hierarchy Management/Usage – Toolbar Button Request
I have a couple of sheets that use hierarchy structure, Multi-level in some cases. To collapse and expand these is a manual process only, however one of my databases in particular I want collapsed as the default. The issue comes when I filter on the required column it is great as you can have it find it and show the…
-
Feature Request: Reminders with a custom days before/after or more day options
I am interested in setting up a reminder for rows where the 'Target Date' column is 30 days away. I'm only able to set reminders 14 days before a date, but it would be really helpful to send reminders at least a month out for more long-term projects.
-
Is it possible to change the dates for holidays for only one spreadsheet?
I am making one for a schedule in another country and I want to be able to change that without changing the holidays for all of my spreadsheets.
-
Filters and Card View
Hi there, It seems that card view is not looking at my filters. On my sheet I have a filter set to open jobs. I use a check box to select which ones are complete and should not be shown. I have the filter on and only open jobs are showing on the sheet view but when I switch over to card view, it's ingoring the filter and…