-
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.
-
Publish to Personal Google Calendar (not Enterprise)
Hello, thanks in advance for your help. I have two Google Calendars, one for work and one for personal. My Smartsheet account is owned by my work Google profile. I have one sheet for work/life task management that is shared with my personal Google profile. I would like to to publish this one sheet to my personal Google…
-
Publish Calendar Link for a Filtered List
Is it possible to publish a calendar link that only displays items form a filtered list isn't of the entire grid?
