-
Need help with date formula
I am trying to create a line chart widget. The chart would display the date an incident or incidents were reported on the X axis. The y axis would display the number of incidents scale. The widget would report the incidents per the last 90 days. Only the date an incident(s) was reported would display. in the chart.…
-
Upcoming Birthday Report
I would like to include a Report Widget that shows upcoming birthdays, but it doesn't seem possible to only pull data according to month and date (whenever I use the date column, it automatically adds the year -- 2018, in this case). Is there anyway that I can pull data for upcoming birthdays w/o relying on the year they…
-
"Dashboards just got better"
Has anyone had any success creating a chart with nonadjacent columns following the recent communication that the charts have more options?
-
Is there a way to have the rows automatically sort ascending by date when new rows are entered?
I have a job board created that jobs are added to and dispatched from the problem is if the jobs are not ented in order by date then I have to manually sort each time. This is a 24/7 process mostly accessed by mobile devices so sort is not an option.
-
How can I summarize people working by hour on a simpe excel sheet?
This might be simple for one of you but it's driving me crazy. Please help. The enclosed pic is part of a simple employee schedule where employee daily hours are entered on a "time in" and "time out" basis. Below the schedule you'll see a breakdown by hours of how many employees are needed for that day (which is entered…
-
Calendars
2 Part Question I want to make 2 employee calendars 1 for vacation another for PTO. Can I create just calendars? I created an installation sheet and a service request sheet. Is there anyway to merge the 2 calendars and color code the installation separate from service request. I would like to be able to view 1 calendar to…
-
Unicode character to allow blank rows in forms
In the spirit of sharing, I thought I'd let you all in on the Arial Unicode Right-To-Left Mark character that can be used in forms to add blank row between Help Text and the form value. As per the image below: * begin by selecting and copying the U+200F character from the Arial set in the Windows Character Map application.…
-
Feature request - dynamic lists
Dynamic lists would be a very valuable feature in smartsheet. When we add a new employee to our system, we need to add them into about 10 different sheets, so that they can select their name from the relevant lists and fill out a timesheet, project reporting etc. If the new employee could be just added to a dynamic…
-
Insert Time Stamp
Is there a way to insert a timestamp into smartsheet when a specific field has updated? I would create a column that it can be stored in I just don't want to have to have the team manually update it. I need to be able to see what was completed yesterday. thanks
-
Best way to report a top of funnel of requests metric
Hello, We are using Smartsheet as an intake form of new projects. What I need to do is do a COUNT of all the projects that came in for this week and also by product type, and region request. However, the only way I can think of doing this is to pull a report that looks at the created date and 7 days back, but I know you…