-
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…
-
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…
-
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…
-
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…
-
Sum of all descendants
Hi I am trying to add a formula to get the sum of all descendants. I have used =SUM(CHILDREN()) but that only adds in direct children. I need to also be able to add in the grandchildren, greatgrandchildren, etc. Any way to do this? thanks
-
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…
-
Custom formatting - individual cells
Excel has the functionality to define custom formats by cell - for example, you can say that for each cell in a range, if the cell value is negative, then the font colour will be red, otherwise it will be black. Does smartsheet have this functionality? So far I can only see fuctionality to format an entire row based on a…
-
Wish list for Smartsheet
Hi, I am new to Smartsheet, and I have been using it this last month to manage one of my projects. One of the area I wish there was some improvements and changes, would be the Update Request area: 1. Be able as Admin to change manually the status of the request, reason being, that I send request to my team over in India,…
-
Hiding fields when a card is being edited
Is there a way to hide some fields so they do not show when a card is being edited? I have put the sheet in the grid view and hidden the columns but they still show up in the card view when I am editing a card.
-
Prevent column name from showing up in Sight
Hi, Has anyone found a way (or is there a way) to prevent a column name from showing up in a Sight? For example, I have a report on my Sight and a row in the report is actually the column name which is different than the Smartsheet column name (Smartsheet column name is "First Name" but the row showing the name is only…
