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…
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…
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…
Any chance we will see additional column formatting to include things like Currency and Phone number formatting?
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…
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.
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.
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…
I have an installation date column and a "week of" column. In our "week of" column, we keep the date of the Monday before. As an example, if the installation date is 1/19/17, the "Week of" column should be 1/16/17. Or, if the date is on a Monday, (Installation 1/23/17), the "Week of" column should be the same as the…
Thinking of this like file explorer so that all of the sheets are organized rather than in one long list for the users I add / share sheets to throughout the team. thanks