Is there a way to automatically send a email when a tasks completion column is changed to a 100 % complete?
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!
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?
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.
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.
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?
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…
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…
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…
I am trying to make a rule that when I am finished with a cell and change a status on that cell it will then transfer it to another sheet. In short when I am finished with a project and have colleceted payment and finished with the set project; that I can make a rule to where it will then have a pre set rule to where I can…
