-
Block Collaborators from Viewing Sheet
I have a few hundred people I need to fill out forms, but I do NOT want them to have any access to my sheet for privacy reasons. Is there a way to get rid of that "View in Smartsheet" link that appears in their update request email? Thank you
-
Enhancement Request: Filters to include and / or functionality
I would like to request the ability to customize filters by adding specific conditions to each row. The filters currently have an option to show rows that match all conditions or an option to show rows that match at least one condition. Because we share our SmartSheets with multiple teams, I would like the ability to add…
-
Formula to display Red Flags
I am attempting to have a RED Flag populate in the "Risk" Column for cells where the "Available Space" is less than 10. Kindly when answering, please complete the entire formula from start to end as from research I tend to get bits and pieces as seen in my screenshot. Thanks,
-
Doing by date and not by task
We are a Habitat for Humanity affiliate. We do a group of different tasks on each day we build. Can I have a task for the days such as Day One, Day Two, Day Three and so on and make that the predecessor for the different tasks done on that day. If not how do I do it.
-
Outlook Add In no longer working
Using Outlook to access an Office365 account, and I have long made extensive use of the Smartsheet Add-in. I've dealt with the browser login issue before, but today I got a new error that is very different. "ADD-IN ERROR" "A problem occurred while trying to reach this add-in" Anybody else getting this?
-
COUNTIF or COUNTIFS
I think I have formulated myself into a corner. What I am attempting to do is create a total number of all open projects based on the multiple status options in 5 separate columns. So, if the data in columns Stats1:Stats5 match X or Y or X, return that total count. I am able to do this for One…
-
Cannot use Outlook Plug-in - Is there alternative (e.g., email address to turn emails into tasks)
Unfortunately my work email address is on-premises Exchange Server so I cannot use the Outlook Plug-in (very disappointing as that would simplify my world tremendously). So far I have not seen an alternative such as a unique email address I can forward emails to auto-add to tasks in smartsheet (such as other productivity…
-
Resource Allocations
New to SS as a licensed user. Stumbling a bit with resource allocations. Wondering if anyone has banged their heads on this as well and came up with a solution to these requirements: - Ability to have a quarterly and annual view of allocations. Currently I can only see it on a weekly interval. - Ability for non licensed…
-
FILTER
Hi, Im struggling to find a way to filter and select.. Just as in excel, i want to be able to filter where it shows all say companies and then tick a company name to allow me to see all the entries starting with that company name. Hope this makes sense
-
Date changes to tomorrow after 5pm
Hello, I have been trying to find a work around for an issue I am having on sheet we use. We are currently using a sheet for employees to submit when they check out and check in equipment via a form. We were using the auto created date column to run reports on what equipment were checked out vs. available. We discovered…
