-
Error message when accessing automations in copy of sheet
Hi folks, I have a sheet that has 16 workflows that I'm trying to take a copy of. All the workflows are accessible in the original, but when I take a copy and try to select 'Manage Workflows', I get the following (extremely helpful) message. Another user has tried to take a copy and come up against the same issue. It is…
-
Access by Outside Users
Hello! I know there are view/edit accessibility options that can be set for outside users when sharing a sheet. However, we want to be able to have outside users approve/deny requests automatically sent through smartsheet forms/requests but not have access to view the sheet itself. Is this possible? When an auto email gets…
-
Calendar view
I've automated a vacation request form; and I see Calendar view in smartsheet, however it only shows the first day instead of all days when the employee is out of the office. Is there a way to show all days in the calendar view that the employee will be out? Thanks.
-
Simple Request Intake & Tracking
I like to use the Simple Request Intake & Tracking for action items that occur during a meeting, but are not part of a specific project, just organization throughout the year on a committee. If I have multiple meetings I am a part of, is there any way to roll these up to a type of Portfolio like the Project Management…
-
How can a general user tell if a Contact listed on a sheet is a licensed user?
As a paid licensed user WITHOUT Admin privileges, is there a way to tell if a Contact listed on a sheet is a licensed user (free or paid) vs someone manually entered? Use case: Automations allow messages to be sent to "Limited" users in the same account or "Unrestricted" any email referenced. However, all contacts visually…
-
Basic Unparseable error
Hi, I'm really confused as to why I can't do a simple COUNTIF. I'm trying to create a summary sheet for a dashboard and simply want to count the amount of "discovery" from a dropdown column. Anyone have any ideas? Thanks Dan =COUNTIF({1 - Sales Pipeline Status Range}"Discovery")
-
Browse window disappears
Since 8/22, while in the browse window, some workspaces that I click on will make the browse window disappear so that I cannot drill down further in the workspace. Not all workspaces cause this. Temporary fix is to get out and get back in or navigate in Recents and hope what I am looking for is there. I am not the only…
-
Function for Working Days Remaining
HI Smartsheet Help Team, I use the following function to calculate the working days remaining. =IF(ISERROR(NETWORKDAYS(TODAY(), [End Date]@row)), "", NETWORKDAYS(TODAY(), [End Date]@row)) However, I want to modify the function so that when it reaches the end date, it will become 0 because right now it becomes a negative…
-
is it possible to create a search form to query existing data in a sheet?
I have a smartsheet with customer data and I don't want the users accessing the sheet directly. Is it possible to create a form where the user enters a customer id number and the form populates with the customer information from the smartsheet row containing that information.
-
Hyperlinks do not work when sheet is exported
Hyperlinks for sheets do not work, when the sheet is exported to a pdf. However it does work when exported to excel. Any reason for this ?