-
MS Power Automate Get Last Row of Data
The desired flow is: Smartsheet form is completed which includes three key pieces of info: Name, Email, Waiver This creates a new row in a Smartsheet A Power Automate flow is triggered where it checks specifically the Waiver (which is a dropdown either needed or not needed). If needed, the flow continues. I built an…
-
How do I add conditions to an existing filter?
Hi, I have an existing filter comprised of 6 predicates which all have to be true. I want to edit this filter to add a predicate (to make 7), but I only seem to be able to remove a predicate, not add one. Can anyone help please? Thanks, GAM
-
Automations Tracker
I have a workflow with nearly 40 automations, half of which are email-based requests for updates with various sets of triggers. While I know the automations work, due to months of testing, when our system went live to the institution, I became very worried that the automations wouldn't run and I'd have no idea whether or…
-
Best way to manage multiple users
Hello, The company I am with has an enterprise license for SS. We have a task where we are storing updates on a spreadsheet, as they evolve, within multiple departments. This has created much discrepancy within the data. I would like to lock it down to about four people being able to enter updates while others submit…
-
Index/Match - Primary Sheet to Individual Sheet
Hi Community, I am looking to track training at the individual employee level as well as for my company overall to provide statistics. Currently I have two sheets. One is the primary tracker, and the second is an individual employee sheet (template). The primary tracker has approximately 107 columns, each column represents…
-
Merged: Ability to wrap line in calendar view
This discussion has been merged.
-
Conditional Formatting - multiple columns
Hi All, Hope you are all safe. Is it possible to apply conditional formatting to multiple columns (same condition). I have data in 10 columns. I want to highlight cells where the value is not equal to 0. Currently I have to apply conditional formatting to each column separately (cloning the rule). Is there a faster way?…
-
RACSI/RACI Matrix with Conditional Formatting
Does anyone have a solution to easily set up conditional format for a RACSI/RACI Matrix without having to clone each RACSI option and setting up a conditional format for each role (in columns)? Like a formula or selecting multiple columns with the same dropdown? I created a traditional RACSI matrix for a customer but got…
-
Clarification on Asset Access When Licensed User Is Downgraded to Viewer (USM Model)
Hi Community, Under the User Subscription Model (USM), I’d like to clarify what happens when a Licensed User who owns sheets or other assets is downgraded to a Viewer. From my understanding: The user will no longer be the owner of the sheet or asset. However, they will still retain access to the item, but only as a Viewer.…
-
How do I include field changes in an email (Automation Question)
Hello: I am creating automations for several of my SmartSheet projects. I have successfully created an automation that alerts me when there are changes to any of 5 critical values in a row within my sheet. However, I am trying to determine how to include which of those 5 values changed in the alert email.