-
How to identify if a checkbox has ever been checked
Good morning, friends of Smartsheet, I need some help working through a process. I have a worksheet that has a checkbox column called 'escalate'. When we check that box, the row shows up on a report that our Compliance group can see, so they know their assistance is needed in some sort of communication efforts. Once the…
-
Use Custom URL to add users to company account.
Use Case: 1. Account Discovery is enabled for company. 2. A user received a shared Smartsheet from a company Smartsheet owner. 3. User clicked on Smartsheet, and it sent him to main screen to create an account. 4. User created an account using his company email. 5. Smartsheet associated his account with the company. 6. A…
-
How to make alert notifications vertically formatted?
I don't want the alert style notifications to send horizontally with a bunch of squished and elongated columns (seen below) I want it to show vertically with up/down scroll:
-
Denial Reasons and workflow
HI all. looking for thoughts on how to provide reason codes when a form submittal goes through the approval workflow but then is declined and providing a denial reason as part of that denial so the submitter can see that in the email response. Thank you
-
Copied Rows need update
I have 2 sheets that copy to each other, the reason being that I have one that only has some cells that I want our customer to see, the other sheet has all our information on it. The question that I have is when someone updates a row, is there some other automation that I can put into the sheet so that we will know that…
-
Automate formula based on dropdown
So I have a sheet with multiple columns. Rows automatically appear based upon a Power Automate flow from other sources and rules. It works great, but now I need to auto populate a calculated formula in one column based on a drop down selection in another. The two things I thought of don’t seem to be working. Example: I…
-
Merged: Move Rows to TOP of another sheet
This discussion has been merged.
-
Non-Admin Viewership of Automations, Workflows, and Forms
We use a lot of sheets, forms, and automations to mages several intakes in our organization, and we have only a couple of people with Admin access to maintain all of this. When we want to make adjustments, changes, or upgrades to a sheet, we are frequently asked to find when in the form logic or automations the change…
-
Automation in Template not Working
I have a template that has an automation that moves rows at a certain time of day to another sheet. When certain users create a sheet using the template the automation is unable to run. with the error "unknown destination". I need some help. Do all users need access to the destination sheet as well? I want to avoid that.
-
Conditional Text
Hello! I am trying to figure out if I can do a sort of conditional text entry. For example, if I enter "St. Bernard" in a cell in column A, then the cell in same row of column B would auto-fill with the word "dog" but If I were to enter "Maine Coon" in a cell in column A, then the cell in Column B would auto-fill with the…