I have an employee list that has a column for "supervisor", which is a "Contact" type column, allowing the selection of a supervisor from a pre-defined list. I have another sheet, a time sheet, which needs to reference that supervisor column with vlookup so that approvals can be sent to that person for hours logged. It…
Hi, I'm trying to look for the settings with regards to the dashboard full screen button. My Firefox is stating that "Full screen mode is disabled by your browser" and I can't seem to find where to enable it. Btw, my problem is not the standard F11 browser full screen but the full screen mode of the dashboard on the…
I have been using Smartsheet to track production and perform P+L on projects at a construction company. I am attempting to have the sheet calculate our percent profit on a project only if our GPM Report checkbox is checked for the job. Ideally I would like to incorporate this into some other calculations as well but I will…
Before today's update to the new improved Smartsheet, when you used a filter it would give you the count of items it filtered on. Now it does not do this. You have to select all elements in a column to see how many there are. Why did this change? Is there another way to find the total number of filtered elements? This is…
In a standard email notification for sheet updates the changes are shown in yellow in the email body, is there a way to define that color to something other than yellow?
After reading several discussions I am completely disappointed that I cannot create a Chart directly from a report. So I am looking to understand some alternative options. I have ONE master sheet that tracks ALL of our department project status'. What I needed was to track ONE teams projects - so I created a report so that…
I export my shipping dates to a sheet that presents the data as a calendar that is printed and posted for our shipping packers and loaders. This is a great tool for allowing those on the team who are not on the computer to plan their workflow. The default color for the calendar grid as well as month and date labels is…
My department manages the production of a quarterly magazine and uses SS for the editorial/content management process. Here is the sheet we currently use: https://publish.smartsheet.com/c95e42926fad4be7ae3463eaf2b228da I'm wondering if this seems like the best process, or if there's a simpler solution to a project that…
Is there any chance to update data on the sheet with new xls without importing it once again ?
Hello, I have used Smartsheet for some time now, but just started investigating using Card view. Unfortunately, Card view cannot be used on a report. Previously I had a report that combined my personal tasks as a manager from one sheet with tasks from my involvement in projects my employees are working on to create my…
Hi, I got an email letting me know that I've been recognized as Automagician, but the link to the badge is not working, and I don't have this badge in my profile here. Can you please advise how to get it? Thanks!
By when the issue will be resolved?
Hi All, I seem to be having a bunch of notification issues, and I'm wondering if anyone else is experiencing issues. Please keep in mind I have had these automations in place for over 2 years already & they always worked as expected. Is this a system-wide issue, or should I connect with Smartsheet Support? Issue 1 -…
Help shape the future of Smartsheet. Share your ideas and feature requests.