-
Autocomplete date range
Hi All, This is likely something quite straight forward that I'm over looking, but hoping someone may be able to advise - Still relativly new to smartsheets. I have a smartsheet, in which each row reports based on week numbers, such as the below formula. =COUNTIFS({Enquiry Tracker (V1) Range 4}, <=DATE(2020, 9, 6),…
-
WorkApps
Tried experimenting with WorkApps this weekend and I am super excited about it, but I do have quite a few questions and blockers at this point, who can I work with to try and get answers or resolution of the issues? I don't want to keep pasting them into new, individual messages and cluttering the community. But I do have…
-
My Smartsheet Wishlist
I wish, I wish upon a sheet that these will someday be a reality...if some of these are already posted, I apologize... Product team - most, if not all, of these were sent to Scott Willeke verbally or via e-mail so he could lend more context. These items are some of the things that would make Smartsheet even smoother.…
-
Approval Workflow Not Working
I have an approval workflow that is currently in use. I referenced and copied the workflow exactly but it is not working the same way. I have it set up so that when a cost is entered in, it sends an approval request to a set group of people dependent on the plant that is selected as well as the amount requested. As I said,…
-
Automated Workflows
Is anyone else having issues with automated workflows? I put in a support ticket yesterday, as simple notifications, when a specific item in a single select field is chosen send an alert to me. Still nothing received and it has been 7 hours. I've tried on three different workspaces/sheets and nothing. Rolling out some…
-
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…
-
Sheet Security - Prevent Sheet Export and Printing
Is there a way to prevent sheet from being able to be exported and / or printed? We have multiple users accessing data with sensitive information on a sheet, however we wouldn't want those users printing or exporting that data, but still keep the access to edit the data on the sheet. Any thoughts?
-
Volunteer Allocation
Hi All, I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific locations (we do not know these specific locations until last minute). I have built a survey…
-
COUNTIFS Description
I believe the description of COUNTIFS is misleading and basically just incorrect. It does not properly describe what it actually does. It says it counts the number of cells but it doesn't. It counts the number of times all given conditions in their respective ranges are met. One match of all given conditions in their…
-
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?