-
Is it possible to conditionally format a row based on the status of it's dependencies?
Hi, I'd like to colour a row, or perhaps set a column based on the status of that rows dependencies. Does anyone know if this is possible? Thanks in advance, Tom
-
Email Reminder When Task is 100% Complete
Is there a way to automatically send a email when a tasks completion column is changed to a 100 % complete?
-
Automatic daily reset of checked column
I'd like to know how to automatically reset the status of checked column daily? Every day when I log in I'd to see all checked columns entries unchecked from the previous day automatically. Thanks!
-
Conditional Formatting editing
Hello, Is there a way to delete a condition(s) from a rule without deleting the entire rule? Or do you have to delete the entire rule and start over with a new rule?
-
Conditional Formatting organization
Hello, Currently the only way to organize all of your conditional formatting rules in a sheet is to "Move to Top" or "Move to Bottom" one by one. If we have tons of rules in a sheet, this can be extremely time consuming. Is there a way to quickly organize rules by priority? Please advise.
-
Can you add a VAT field in a smartsheet?
I want to add a field that automatically works out the VAT in a seperate field so i can calculate how much VAT we pay on services. Is this possible? I have tried to add a formula e.g =SUM(amount)*20% and also +=SUM(amount)*0.2 Neither of these work - it just shows an error message.
-
How do i create a multiple line column heading?
With Excel, we can enter a column name, and create a line break with the Alt-Enter key combination. How can we get the same effect (one or more lines in the column names) with Smartsheet?
-
Conditional formatting for checkboxes
Hi! I'm writing a smartsheet for basically keeping track of a checklist - I was wondering how to write the nested conditional formatting (like for Harvey Balls) but with a checklist. So if rows 4-7 in the "Complete" column are all ticked then the box in row 3 will be ticked. I'm happy with the formula needed but don't know…
-
exact match formula in Smartsheet
Hi, has anyone had any luck using an exact match formula is Smartsheet? I have two columns that have text in them. I want the 3rd column to tell me if column 1 and 2 are an exact match or not. I know how to do it in excel =Exact(A1:B1) but not sure how to set up in Smartsheet. Also, can you apply a formula to an entire…
-
Preparing the Process
Hi to everyone I would like share with others users my questions about peparing the sheet for organize the jobs of the company where I work to see what are you guys think about this subject. I have to organize and follow every job of the company. The company have a lot of jobs (many hundreds) and in each jobs have about 15…
