-
How to alert person in next row
I have an onboarding worksheet where each row is assigned to someone and I would like for the person in the next row to be alerted once the row above theirs has a completion date. Can this be done in smartsheets?
-
How do I count how many cells are last month but not considered expired?
I am working on a sheet for currency of qualifications for our employees. I have the equations that will tell me how many employees are a month before they are due, how many are due this month, and how many are in the past but now I have to find and equation that will let me count how many qualification are only one month…
-
Simplest way to update staff on onboarding tasks
My organization (a small physicians office) is creating a new onboarding check list via smartsheet. We want to update the staff on certain tasks they need to complete for new staff members going through the process. I've considered a few options but wanted to ask if anyone had an idea on how to do this. Thanks
-
Check Box Question
Can you make a requirement to fill out specific boxes before you are able to check the checkbox? So basically you can't check the box unless Column/Row A1 -- B19 -- and M24?
-
Reports using HOURS past Creation Date/Time Criteria
Hello friends, I need to be able to create a REPORT where the only rows that appear are those that are equal to or greater than 3 hours past the Creation Date/Time. Is this possible?
-
Formula/pie chart help?
I'd like to have a pie chart that shows a dynamic count of orders "pending/fulfilled/cancelled" of the last seven days. Ideally, there would be four separate ones for four locations (which will be presented on their personal dashboards), as well as a master graph that compiles the data for all four into one for upper…
-
how do you import an excel date/timestamp into smart sheet and have both date/time shown?
I captured date/timestamp in smart sheet 09/17/2020 13:35:44 and loaded this into smart sheet but the loaded value truncated the time, i.e, when loaded smart sheet showed 09/17/2020, but the time stamp was lost (truncated off). How can i also get the time stamp to be loaded, either in the same field or a departe field?
-
Form from one sheet populates another sheet
Hello SS gurus, I am relatively new to SS "in the field", although I've watched over 20 hours of videos from the SS Learning Center so I have a good understanding of the mechanics. Here is what I'm trying to do... We need to track inventory in our supply room: items on hand, items removed, items added, etc. We would prefer…
-
Find all similar entry names and add their qty
Hello I have a sheet I made where I load in all my orders of items needed for a job. Each Item has a code assigned to it I'm calling the Entry Name. There will be times where the same Code/Entry Name will appear several times during the life of the project. For Example This week I might need 4 - BT01 (Entry Name) then as…
-
Cannot transfer ownership of Smartsheet Calendar
I am trying to transfer ownership of a Smartsheet Calendar to a coworker, but when I try, it is giving me an error message, saying that the user isn't found and new user needs to be shared to the source sheet/report as an Admin in Smartsheet. I have checked, and this coworker is already an admin in all of the source…