-
Logic in Forms
I am looking for a solution to use logic in a form for the following: Column: Chose a Fruit? Drop Down Apples, Oranges, etc. Then from logic, I would like to have it access a column that has different types of Apples. Such as Honeycrisp, Gala, etc. Is it possible to have logic access different columns with additional…
-
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
-
How can I keep my grouping and summaries when exporting a report?
When I go to export my report as an excel or PDF, it does not carry any of the summaries and grouping. How can I fix this or work around this? Here is an example of my report vs what exported ( a portion)
-
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?…
-
How do I apply conditional formatting to a single cell?
Hello, How do I apply conditional formatting to a specific cell? For the example below, when I click on the "B/C" check box, I only want to highlight the B/C within that row and not that column. Wasn't sure of the best way to do this.
-
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…
-
Send as PDF Attachment from Smartsheet
I've "starred" the lines I wish to be viewed in calendar view. I've clicked on Calendar view, filtered by starred items, went to File, Send as Attachment, entered my email, selected the PDF option and hit send. When I receive the email with the PDF attachment, the PDF will not open. It acts like it's going to but will not.…
-
Tracking for a Bill of Materials (BOM)
We are a wholesale distributor and are looking for a way we can track multiple (10-20) construction projects in one workspace. In each project, there is project header information that needs to be statused and tracked, and a bill of materials that we need to upload via CSV to the project. This BOM material includes…
-
"Sharing to People Who Have Multiple Email Addresses"
A former employee has returned to work with us as a contractor. Her old company email is still in various Smartsheet workspaces. When I delete it and attempt to re-share the sheet to her contractor email, I get a popup saying "You're sharing to people who have multiple email addresses. You'll be sharing this workspace to…
-
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.…
