-
Report not Matching Formula Issue
Hi, I have created a report to use on a dashboard for showing the number of job cards to print for our workshop. The report is shown below, and you can see that there are different amount of jobs to be printed for each workshop: You will see on here that there is: * 3x for the FASTRACK Workshop * 10x for the Van Workshop *…
-
Calender based on a report
I want to run a report that pulls data from several different project schedules and tie them together into a overall calendar. Is there anyway to add formatting to a report or to have a sheet mirror the information that is run on the port? I need to either A: Be able to format the calendar on the report(I know that reports…
-
Calendar App Filters
Within the sheet/report, I have a Contact List column that contains multiple contacts per cell. However, when the Contact List column is used as a filter within the Calendar App, these multiple contacts per cell are not broken out into single values. Is there a way to separate values within the Calendar App filter? Or does…
-
Change first day of week to MONDAY, instead of SUNDAY
in the German speaking part of Europe, a calendar is usually shown with MONDAY being the first day, and both Weekend days SAT and SUN at the end of the calendar. This should be something that is user specific. So where in the user setting can either the admin or the user himself change the first day of the week from SUN to…
-
Displaying range of dates on a Dashboard
Hi Smartsheet Community, My team currently utilizes a report with multiple sheets to track the due dates of projects. We currently use the Calendar app to display this info - but I'm looking to build an additional dashboard for my team that will utilize this report to display the upcoming due dates in a two-week window.…
-
Losing Data & Slow Performance
Hi, just recently my Smartsheet is going really slow, and I'm losing information I've just entered. I can't drag information from one cell to another, and can take 3 seconds or longer to load information, and half the time the file doesn't actually attach. I have to close down and reopen Smartsheet all the time so it saves…
-
Show only own tasks in calendar
Hi, I am new to Smartsheet. I already searched for this topic, but wasn't successful. By standard, the calendar in Smartsheet shows all tasks of everybody. I imported the calender into my Google calendar (via ics and directly). There also all tasks of everybody are shown. Is there a way to show only your own tasks (you are…
-
Publishing only filtered list to google calendar
I'm having an issues with "Publish to Googgle Calendar". Every time I've publish some task in google from SamrtSheet, SmartSheet publishes everything in my Google calendar instead of publishing the specific tasks assigned to me. I've attached a detailed description of the issue I'm facing with screenshots. Does anyone know…
-
Limiting tasks (by name) to specific days of the week
Hi, I'm looking for a way to control specific tasks being allowed to start on only certain days of the week. For instance, a task name containing "A" is not allowed to occur on Mon or Fri, only possible to start/finish on Tue, Wed, or Thu. Keep in mind, A is a precedent for B, which is a precedent for C. But B and C are…
-
Return 1st column value if 2nd and 3rd column is blank
Hello, I am trying to come up with a solution for my smartsheet involving 4 columns (4th being the result column). I wanted to return the value from the 1st column whenever 2nd and 3rd column are blank, if not return the value from either 2nd or 3rd column. These columns contains dates by the way. Sent (1st) ; Won (2nd) ;…
