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 2017 Posts
Archives for January 2017
Discussion List
Change cell format within a formatted column
This seems a no-brainer but maybe not: I have a column formatted as a drop-down menu, but within this column are other cells that need to be formatted in other ways, such as dates, currency, and others. Any way to do this? Thanks in advance. Dennis
Add text in addition to primary?
Hi - I'm using SS to track some dates for several projects. My gantt and calendar show the text from the primary column which I want. But I don't see a way to add the project name to the calendar or gantt. Can I? Thanks
Automatically including new rows in formula
Other than SUM(CHILDREN()), what's another way to include newly added rows into formulas? My scenario is this: I have a parent with multiple children, and new children are guaranteed to come in. I want to sum a column based on the condition of another column. How can I use the SUMIF to include newly added rows without…
EOMONTH formula request
I would really like to see the EOMONTH formula. There is a way to do that with the current formulas, but as an example of how long it is, here is what's needed for setting a due date to the end of the current month if there are more than 10 days left in the month or setting it to the following month if there are less than…
Roll-up metrics for an Insight - Help needed
I am creating a dashboard for all my development work. My tasks sheet is pretty standard with Assigned to, Status, Phase, Effort The metrics I am looking to display are: * - Total number of days (Effort) per developer * - Total number of tasks in a given Status (but exclude some rows in given phase) * - Total number of…
Lock a Sheet
Hi, Is there any functionality to lock a specific sheet. I dont think there is but this would really help for the situations explained below. There are two scenarios: Scenario 1 We have a master sheet, where all product information is pooled. there are 100 different columns and hundreds of rows. One team is responsible for…
Hyperlinking Images?
Hello- I am working on converting an inventory spreadsheet that is currently in excel and moving it over to Smartsheet for additional functionality. I would like to include images - is it possible to actually hyperlink an image once it is attached? Thank you!
Resource Allocation across multiple Smartsheet accounts
I'm experimenting with Smartsheet to assess suitability to manage multiple engineering projects. Question I have on resource management - if I have a number of projects within my work-space and a colleague has similar but seperate (but we do not access or collaborate on each others) and we need to share a common resource…
Duration Logic on Start Column
Is there any logic that is not obvious running behind the scenes on the "Duration" column that affects the "Start Date"? See picture below. On Training Day 18 deliverable, each task is taking 0.25h and the rolled-up total is 0.156d. Why row 368 is pushed to the next day ("3/22/2017") if all tasks above it are less than 8…
Formula Help
So I need some help with a forumla, not sure if its possible or not. New to smart sheets as well so im hoping for some guidance. I have a Sales Pipeline document that ive created to track all projects in the sales pipline with summary info at the top of the page on how many jobs are in each stage of the process and the $…