-
Help setting up a daily tracker
Hello! My team is attempting to create a sheet and form that counts the amount of inventory of a product we are overselling per day. We essentially would have the inventory start with 15 units per day, we are going to request the number they sold for each entry. The goal is to have the number they enter in the form will be…
-
Any LMS/Content Managers using Smartsheet to track their content? Do you mind sharing?
My team manages training content for a specific part of our organization and we have content that can be as old as 2016 to as new as of yesterday. For a few weeks now, I've been trying to figure out a way to track "content" (right now, just LMS courses) we own in Smartsheet so I can share with leadership "This is…
-
How to set up recurring task schedule for Payroll team?
Hello all! My company's Payroll team is seeking a task management solution to help them track recurring to-do's related to payroll processing. We are on a 24 period pay cycle (15th and last) and there are some tasks that need to happen every cycle, some that happen periodically or annually, as well as one-offs. They'd like…
-
Video Editing Software Discussion in Smartsheet Community
Hello Smartsheet Community, I wanted to kick off a discussion about video editing software, and how it can complement our project management efforts in Smartsheet. Here are a few topics to consider: Favorite Software: What video editing tools do you use? How do they integrate with your projects in Smartsheet? Tips and…
-
Does anyone else have issues with Smartsheet not fitting within your screen? (Grid View)
I've always had issues (in grid view) with the current cell being able to go offscreen at the bottom, but now I'm also having issues with the current cell being able to go offscreen to the right when the workspace panel is open. The bottom one is manageable, because you can just keep arrowing down to new rows, but you…
-
Right Click new Tab or window
Enable Standard Browser shortcuts - Smartsheet has disabled some standard browser functions. This is one of the top 10 complaints I get from users. you can not right-click and open anything in a new tab or window. You can not hit Ctrl+Click to open in a new Tab. Mainly the left toolbar. I would like to see all standard…
-
VLOOKUP to another sheet - cannot pull these fields into a report, getting #ERROR
I am using VLOOKUP in a sheet (call it Sheet2) to pull data from anotther sheet (Sheet1). Then, I'm creating a report that pulls data from Sheet2. This report is pulling some of the data from these VLOOKUP columns. I'm seeing an issue where the report can only successfully pull data in sometimes. Sometimes I open the…
-
Trouble creating exact match formulas to list tasks associated with specific departments.
I'm working on a set of formulas that will find the tasks and list them for the exact matches of the below Department names (among many others). I' have a formula that will work for a few of them but not all of them. As you can see they have similar letters (EDI and IT) and the results they return overlap each other, or…
-
Merged: Enhance Dynamic View with Grid, Calendar, Board, Gantt, and Card Views
This discussion has been merged.
-
How to get the same name from two different sheets to populate a third cell based off their response
I have a sheet (Sheet 1) that is being populated with a person's information after they fill out a form. Smartsheet then sends out an email to that person through a workflow to follow-up with them. The email contains a smartsheet form that allows the person to put their name and follow-up answer. This is populating Sheet…