-
Time Formats - Number formats - Rethinking the UX and function
Having an entire dialog for text and number formats would make much more sense to me.. combine the currency, percentage, thousands and decimal places into it's own dialog box. We really NEED a way to save and modify the formatting of common things. So as to have them available and globally modifiable across workspaces. Use…
-
Calendar App - Filters...why did you change the functionality...now...during a Pandemic?!?!?
Smartsheet, Before I lose my mind, here... please tell me that there is (at the very least) a way for individual users to create filters without being shared to the underlying sheet. Up until this change, our users were able to access the calendar and manually select the criteria that they wished to view via multiple,…
-
Building tasks in Smartsheet: How to sort by dates instead of parent groups
I'm in the throes of building my first sheet and have finished setting up the dependencies and key tasks I need for my project. Tasks are set up by parent/child groups, based on task type. Now I want to build out the rest of the year using similar tasks. At this point, I want to be able to manipulate the sheet to look at…
-
Plotting cost over time
Hi- I am trying to either graphically or with subtotals display cost over time as aggregated preferably by month, but also want to consider by week. I am easily able to plot cost for items that begin or end in a calendar month, but not for items that span months. I am pretty sure each cost would need to be broken down into…
-
How many rows can a report collect?
I created a report that pulls data from 4 different sheets. It has multiple items on a single date, so calendar view is the only view I am interested in using. The data on the sheets goes up to May, but in the report, it stops showing at April 15. When I look at the report in Grid mode, it is exactly 500 rows. How can I…
-
Change Color of 'Color by Column' on Calendar App
Hello! Is there a way to change the colors set by the 'Color by Column' design option on the Calendar App?
-
Calendar App Legend
Hi, I'm new to Smartsheets and am experimenting with the Calendar App add-on. It seems like a great tool, but I'm having difficulty with the legend. When I created my first calendar using the app, there was a legend at the bottom, but now it's gone. I don't think I did anything different, however, there are multiple users…
-
Changing the colours assigned to various groups in the Calender App
Hello, I want each name to have a different colour in the Calender App. I can select "Color by Column" and it works but I find the automatically chosen colours to be garish and I would like to set my own. However, the option to change the colour does not appear on the right (see picture) I have another column where this…
-
Calendar formatting to indicate event is cancelled
Hi, I'm wondering if there is something like conditional formatting for the Calendar app where if the Status Column of the source report = cancelled, then the event would be highlighted is a different color. That would be ideal, but if anyone has ideas about how to visually indicate which events are cancelled on a…
-
Conditional Formatting Grid View v. Calendar View
I am new to SmartSheet. I have a column called "Conference Call." I set a conditional format that appears correctly in the grid view but not in the calendar view. I'd like the word font/color to appear the same in the calendar view that it does in the grid view. I am attaching screen shots.