-
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…
-
Counting overdue on multiple sheets
I cannot for the life of me figure out how to get the overdue which is in a date field in red text, counted on multiple sheets and only if its not complete, or not cancelled - everytime we try, it get 0 which is inaccurate =COUNTIFS({Exp_Status}, <>"Complete", {Exp_Due}, <TODAY())
-
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.
-
Export formula to Excel
I am trying to export a budget sheet that has formulas to Excel and still have the ability to manipuate the numbers with the same formula, but it does not carry the formula with the export. Is there a way to preserve that formula during export? or is there some other way to export the data and keep access to the original…
-
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.
