-
Dropdown Lists by Individual Cell rather than by Column
Hi all, I was just wondering if there is something I am missing here. Is there any way to create dropdown options by cell rather than for the whole column? I am trying to create a Creative Brief and there are a lot of fields that I want to be able to control the options people can choose from, rather than allow free text.…
-
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…
