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.