-
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.
-
User Interface to collect smartsheet data
I have a smartsheet with data, I would like create a UI for other people where when they just type one of the specific data (such as name) and information about that row pops up without even opening the smartsheet. So it is easier and quicker to retrieve data.
-
Replacing form entries instead of copying
I have a smartsheet with a form automation that collects information like a survey. However I want to make it so when an entry with detail such as name is already in the smartsheet it replaces it with the new form data rather than creating a new entry.
-
Parent Task to Child Task Automation
Quick Question; Is there a way or work around in automation such that when a child task is past due, the parent task status can move to "At Risk"? Seems like something that should be simple, and maybe it is, but I'm not able to develop a work around. Thanks in advance.
-
How do I make a form field's visibility dependent on 2 fields?
Hi, I've been struggling with this with my favourite AI for over an hour now and I've hit a wall. I want to implement the following: if [CheckboxA] show field 1 if [CheckboxB] show field 2 if [CheckboxA and CheckboxB] show field 3 There is no way to do this within SmartSheet forms. You have to have a helper column in the…
-
Sheet modifiedAt
Hello, I found that sheet modifiedAt field in "List Sheets" GET method sometimes is different than modifiedAt field from "Get Sheet". Is this normal ? When I change a value in a cell, Get Sheet method returns the last modifiedAt date but List Sheets remain with the old value.