Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums. Archived 2016 Posts
Archives for February 2016
Discussion List
Sumif for date ranges
This did not seem to be covered and I'm hoping to find a formula without adding extra columns to my sheet. Curently I have a secondary column separately maintained which lists months and I Sumif by this secondary "month" column. I would like to Sumif based on date ranges. Not simply from today() but actual Date A - Date B…
Gantt Chart Printing with Current Date
Is there a way to print the current date dashed line that appears in the Gantt chart view on the screen when printing to a pdf? Having that visual cue would really help when printing this out for others. Thanks. Ryan
Resource Allocation
I'm having problems with the Resource Allocation column. I created column, set it up for Resource Allocation in Project settings, but no matter what I enter in the cell for each task, the number defaults to 1
Using templates
can anyone explain how to import a template into an exist sheet as an editor?
CountIF where cell contains specific word
Hi I've read a few posts and dicussions but still can't seem to find an answer that I can use. I'm collecting data and have some basic dashboards setup which display the number specific words are recorded. As an example: Clinical Clinical Lead Clinical Specialist Lead Operational Lead I need to be able to count how many…
Cashflow Overview from Date columns
Hi all, i have checked almost every single discussions, but still looking for my solution: Case: building houses with 6 payment steps from our customers (revenue), and consider 6-8 payment steps for our contractors (cost) Note: this part we are able to do 1.) finally have a mastersheet with follow columns: January-December…
Diamond shaped icon
At the beginnig I saw a diomond-shaped icon but then I erased it. How can I put these icon to the Gantt chart to determine a specific date such as release of a product??? Can somebody help me please??
https:///smartsheetlabs.com
Hi Smartsheet, A simple development request to fix an issue......Not urgent but hopefully a simple fix. Not sure where to submit this, but I am sure someone will. The link from the < Account / Apps and Integrations > < Apps > The popup shows a to smartsheetlabs has an extra / (forward slash) and fails to connect.…
Checkboxes
Is it possible to remove a checkbox out of a single cell even when you require them in the rest of the column?
How to remove slashes from formula that includes date field?
I am using a formula to concatenate several fields, one of which is a date field which contains forward slashes (e.g. 02/09/16). Is it possible to modify the formula so that it removes the slashes from the end result and appears as 020916?