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.
Discussion List
Number of years/month between TODAY and a given date not working
NEw trial user ;^) Have a very basic calculation. From a Purchase Date I would like to calculate the number of Years and Months that have passed since purchase date from TODAY. Two fields: Purchase Date: Date Age: calculated difference of TODAY() - Purchase Date. But each forumula comes back #unparaseable. But most work in…
Scheduling resources (internal & external) without a Project Plan
I am working with a client (outside construction with internal and external resources) who wants to create and maintain a scheduling workspace/tool. Presently, they assign work in teams against various initiatives and urgent work orders. The goal is to ensure all resources are fully utilized and work is prioritized. When a…
Possible to close Comments window using a keyboard shortcut?
Does anyone know it the Comments window can be closed using a keyboard shortcut or are we required to click on the 'X' icon in the top-right corner?
phone numbers
how do i make a phone number in a cell able to be clicked on so that my phone recognises it as a number and auto selects the phone function?
Autofill Capabilities based off of Dropdown selections?
When selecting from a dropdown menu, can you build corresponding autofill capabilities into the next cell? I have a dropdown list of classifications that correspond to a weighting system. I'd like to be able to select a specific classification and have the following weight cell autopopulate. Is that possible through a…
COUNTIFS on the same column
Hi, I'm trying to create a formula, which runs a count on a particular column e.g. 'Status' column, with values of 'In Progress', 'Build' and 'QA'. I would like to find the total number of projects that have a status of: 'In Progress' and 'Build' I'm using the COUNTIFS formula, however no luck so far. Any ideas would be…
Update request to mailer doesn't work?
Is there an accepted practice for sending an update request to multiple people? A contact column can only accept one contact rather than a list. I tried sending an update to a pre-defined mailer list, but when I send these requests, no-one on the mailer receives the email?! I can see the email being sent because I am on cc…
format row with color on date
i have two columns, one is today date collumn and other is review date coloum , if my review date was 20-12-2016 and it today date is 21-12-2016, and it expired i want full row colour changed format and receive reminder setup. thanks you
Cell Linking with Auto-Numbered/System Created (Date)
Hi All, When cell linking an Auto-Numbered/System Created (Date), why does the time stamp section not link as well? For example; In one sheet i have an Auto-Numbered/System Created (Date) displaying [08/4/16 13:22] but in the linked cell it only shows [08/04/16] no timestamp is carried across. Where am i going wrong?…
% Complete column is missing
I have created a project that seems to be working OK. I just noticed the % complete column is missing. It's quite possible that I deleted it without recognizing its significance - don't really know. How do I re-insert it. I have looked at the column insertion options and don't see it there.
