I am trying to create a formula that will Sum the (Distinct Value from Column 1* the Qty in the same Row) + the Count of distinct values in Column1 for a total to be calculated in another Sheet next to the Distinct value. There may be an easier or more straight forward way to do this but I am not sure. Below is an example…
I went through hell trying to figure out what is causing my conditional formatting to suddenly stop working when it was working perfectly in the past. My sheet is shared by 104 people. After many hours scratching my head and calling support we figured out the issue. SOMEONE TURNED ON HIGHLIGHT CHANGES and made the…
The ability to apply conditional formatting rules from within a report would be huge. Having to modify the Source sheet for a specific report doesn't seem to be very efficient.
I'm looking for a way to set conditional formatting to a date field on our Smartsheet. Currently we capture "Date Submit Legal" and "Date Legal Approved". I would like to find a way to change the font to red if the approved date is prior to the submit date. Since this is a manual field we are finding on occasion the date…
I know how to copy info from one sheet to another sheet. My question is...I've created an Application form for my employees to fill out. Is there a way to set up where a new sheet is created for each applicant and copies their info to it also. Meaning...Joe Smith fills out my application - then Smartsheets creates a brand…
I have each assigned to person with conditional format with a color to let them know what they are assigned to work, but what if i need two or more associates to work that particular assignment, how do i set up conditional formatting for that, or would that be a formula?
I need to create a Smartsheet for tracking documents, the date of last review and a color changing column reflecting the date of next review. In column A I need to list the document names. In column B I need to list the date of last review. I need help to format column C cells. 1. I need for Column C to populate a date…
Hello! I have a workspace with a ton of different sheets that each represent a project timeline for a single client. We are creating different reports to pull together program/client level views for things like team PTO, client due dates, internal resourcing priorities, etc. We use the calendar view of our reports…
We would love to have the capability to push new conditional formatting using global update for provisioned project sheets. We have over 200 projects and whenever we get new ask for new conditional formatting (since things change all the time), it's a huge manual hours to go through and update each provisioned project with…
I would love to be able to be able to apply a conditional formatting template to any sheet I wished - much like a design theme in Office 365. And - if I change a rule, it would change it for all the sheets using that template. Can you imagine? How wonderful!