-
Can't Create a Single Grid Sheet anymore? Why did this change?
I am unable to easily create a grid sheet unless I do it through the Workspace panel. I used to be able to right-click anywhere in my sheets folder, for example, and add one, or hit the create button, which offered options. Now, the create option directs me to the same location as the left navigation, and there are so many…
-
How do assets within a Collection appear to end users?
I have external users who can't be shared to a Workspace because there is confidential information regarding other external users within the Workspace. A collection seems to be a good option, but how do these users see the assets within the collection? I tested it this out on a secondary account, and can see the collection…
-
Change Dropdown Column Value for Multiple Rows at One Time
Simple question here: I want to change the Dropdown value of multiple rows at the same time. Select Rows, 3, 5, 6, and 8. Change these rows' Column B (dropdown) value to "Value X". Right now I can select multiple rows by clicking while holding shift. But then when I try to change the column value for them all, it just…
-
upgrade plans
Can you please ask my account manager to send invoice for Pro Plan for my account to the email ID: karthikeyan@bkstextiles.in to enable me to process the payment through wire transfer
-
COUNTIF Formula for Checkbox Column Not Working in Sheet Summary
I'm trying to create a formula in the Sheet Summary that shows the number of checked items in a Checkbox column named Pending, out of the total number of rows that have either a checked or unchecked box (i.e., excluding blanks). =COUNTIF([Pending]:[Pending], 1) + "/" + (COUNTIF([Pending]:[Pending], 1) +…
-
Automation Not Triggering On its Own When Trigger Criteria Met
Hi - I am using Smartsheet to manage our cutover plan for a software deployment. I have 2 columns that populate a Yes/No value automatically based on a formula calculation. Those columns are called 'Trigger Date' and 'Trigger Time Comparison'. The 'Trigger Time Comparison' is always the last column to flip to Yes, so I set…
-
Quick question about submission not showing up on record
Hi all, Part of our workflow for documenting tasks is submitting a form to a supervisor, which they then will approve as completed. This has been done for months with no problems Today I submitted multiple of these, all of which said either "submitted" or "approved" like normal. However, two of them are blank, telling me…
-
How to Automate Email to the Submitter?
I'm trying to set up an automation that will email the submitter once their request has been set to a status called "Approved". I made a Contact list column for the submitter to enter their own email, but when testing this automation, the submitter never got an email. Any help with this would be greatly appreciated!
-
Contact Support Cases List should include SS Tech-Generated Cases
I looked for cases that were started with a phone call and was told that these do not appear in the Contact Support Cases list. The email gave the Case #, but all the updates have to occur through email instead of being updated in the portal. Would it be a quick fix to include both the cases started in the portal and those…
-
Show Multi-Contacts with a JOIN(COLLECT(...) formula -- working, but not showing as contacts
I have a Directory Sheet ('Sheet 2 -- Directory': https://app.smartsheet.com/b/publish?EQBCT=a3e35afe3e02404692195182d00936a4) with a list of Teams, Departments, and Contacts. I want to pull the Contact(s) into another Sheet ('Sheet 1 -- Pull Into Sheet':…