-
Report Builder Gantt Chart is off
I've been playing around with report builder, to create a summary page of all my sheets. I have a check box I use to filter the lines I want on the report, which are typically the first/top line, which is the entire project. The Gantt view in each sheet is correct, but in the report, every line has the gannt shifted by one…
-
Print smart sheet
Dear All I want away to print smart sheet chart but only page only A3 or A4 . All the time it comes in many pages . Thanks
-
IMPORTS
CAN I IMPORT INFO FROM OUTLOOK CALANDERS TO SMARTSHEET.
-
20th of the following month formula
I have a situation where a sale rep gets paid commission 20th of the following month. I need a formula to look at the "Invoiced Date" say 16/02/17 and automatically enter 20/03/17 into the "Commission Date" . Then i need a cell (highlighted in blue in sheet) to calculate the commission when in rolls over into that…
-
Count Risks only when checkbox is open
I'm trying to create a formula that only counts the risks (High, Medium, Low) when the completed checkbox is not checked off. I have a formula for counting the number of risks (=COUNTIF(Risk:Risk, "High") + COUNTIF(Risk:Risk, "Medium") + COUNTIF(Risk:Risk, "Low")) but I have another column for "completed" that I want to…
-
Scheduled Monthly report of previous month's activity
to all my formula gurus, Need some help thinking this through. I want to schedule a report that runs on the first of the month and pulls all data from a sheet where a "Closed Date" occured within the previous month. So on Feb 1, the report would pull all activity in the month of January where the "Date Closed" occurred…
-
Default Currency Value
It would sure be nice if you could set a default currency type in the account settings so that you don't have to select the currency type every time. We always bill in US$, but every time I create a column or enter a value in a currency field that hasn't already been defined at the column level, I have to select the value…
-
What determines the country (currency) of a sheet
Prior to the latest release currency columns displayed as $0,000.00. Now it displays as CA$0,000.00 which adds clutter. All our computers have US as regional Settings. If I change my personal seettings to Canada the CA goes away but the date format is d-m-y and can't be changed to m-d-y, so changing the settings is not an…
-
What formula should I use to count R,Y,G symbols in a column?
Hey folks, I want to count the number of red, yellow, and green symbols in a column. Does anyone know the formula to achieve that result? Thanks, Kenny
-
numbering child rows
I have a sheet I've been using for a while. I just added a column and set it up to auto number. All the rows increased sequentially, e.g. 1, 2, 3 etc. The child rows, and their child rows continued in orer, in otherwords the child of parent row #1 was #2. I'd like the child of Row #1, to be 1.1 or something like that. Be…
