-
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':…
-
Help For Colorblind Folks
Good morning! I struggle with trying to pick the appropriate colors from the fill and text palettes due to red-green color blindness. Would it be possible to have a text bubble with the name of the color pop up when you mouse over each color in a palette in any area of the application? It would be a huge help when…
-
Dashboards and Presentations
What are your best practices for using the dashboards for presentations to executive level? I am having difficulty displaying a dashboard within a PowerPoint presentation and screenshots are just not the best or most effective. Thank you!