- How do I add a space in a reference formula? I want the space to display between the two values that
Good Afternoon, I have built an event calendar tracker. I want the display name on the calendar to include information from two columns of data. The formula I am using for calendar display is =Location1 + [Event Name]1. In the calendar display column I want a space between the location and event name.
- 2 questions: Reminders/Alerts & Dates in a contacts' calendar possible?
When we set reminders/alerts it goes out as an email. Is there another option for the reminder to appear a a pop up as in outlook? Also, if we have a contact column and a date column, is it possible for the dates assigned to certain contacts be imported in their outlook calendar? And then they could have a reminder that…
- Can I hide the weekend days for a task?
I have a task that spans a weekend. It does the correct calculation for the correct number of working days, but in the calendar it's a bit misleading for our team. It makes it appear as if the task is being worked on during the weekend. I would rather have it only displayed for the 'working days' per the calendar settings.…
- Planning Calendar conundrums
Hi, Community! I am wondering if anyone else is using SmartSheet for an institutional planning calendar. I chose a template of project with gantt. Most of the tasks on the calendar, however, are annual, bi-annual, semi-annual, etc. I am trying to figure out the best way to handle that. Would I only be able to do it using…
- 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…
- Calendar App - filter disappeared?
For some reason, I no longer see the filter for my calendar in the Calendar App. I was able to see it still yesterday and to filter columns based on my settings, but now the "funnel" icon is no longer visible and replaced by "filter off" text. I have not made any changes to the underlying sheet or calendar settings since I…
- 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…