-
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…
-
Setting Rules and Conditional Formatting
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…
-
Locking a Summary Row
Hello, Is it possible to have a summary row at the top of my sheet that is "locked" sort of. Meaning, when i filter on certain criteria, the summary row will only total that criteria.??
-
Preserve leading 0's:
-
Make Stars yellow by Default
I am creating a New Hire Checklist and one of the columns is called required. If that row's task is required the start will be checked and show up yellow. How do I make all the starrs in the required colum yellow by default? So we have to uncheck only what isn't required instead of vice versa.
-
Autofilling Columns on different sheets
Is there any way to auto fill columns on different sheets. We run hundreds of events a year and it would be great if when we add an event the name of the event and other details are automatically added to our various staff members sheets without us having to send them all a memo of a new event to add.