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 December 2016
Discussion List
Enhance Request - Format Painter
Reqeusted Feature: On a sheet with many rows and cells to paint, the constant resampling of the source area is tedious, so.... Double Click on the format painter control holds the sample being painted until <escape> is ticked. Allows painting on discontinuous areas without having to constantly go back to resample the…
Possible to set time for tasl dates and reminders?
Hi, Is it possible to set time (HH:MM) for task dates and reminders? Thanks, Carlos
Sales Template Help
I’m using template, “Sales Pipeline by Rep”. Instead of using Rep name as the main category, I would like to use the Account/Company name. This way I can sort opportunities by the customer name. * I would like the total sum values to still sort by category (which is now customer), but filtered by status. Only the items…
Merry Christmas!
I have really enjoyed this community this year and wanted to wish everyone a Merry Christmas and a Happy New Year! Tony
Number of Days Ticket is Open
Hello all. I am a newbiw to Smartsheet, and I'm having trouble correctly adding a formula to one of my sheets. I have a repair sheet with a column that shows the date the ticket was created and a column that is labled number of days open. How can I have this column automatically display the number of days the ticket is…
How to display the grandparent task name or value in a cell
Hello, I would like to display the name or value in a cell, please. I could get the parent by: IF(ISNUMBER([Stages Tasks]6), PARENT([Stages Tasks]6), "") but I would like to get the Grandarent instead. Thx for your help.
Calendar vs Fiscal Year/Quarters settings
Hello, I was wondering if there's a way to update the calendar/gantt settings to use quarters based off of our fiscal year. Is that an option? Example - Q1 would be November-January Thanks, -PJ
Automatically update formula every month
Hi, I have a sheet listing expenses for every month this year, and expenses for every month last year (Jan 2015, Jan 2016, Feb 2015, Feb 2016 etc). There is also a column for Total YTD 2015, Total YTD 2016 (if today is December, it would add Jan-Nov 2015 in one column and Jan-Nov 2016 in a column next to it; for…
Template Description
I saved a sheet as a template and entered information about updates I made into the optional template description field. I cannot find the text I entered anywhere. Where does that information go?
IF/AND Functions
I am trying to create a sheet that will auto update a number in a cell using multiple IF AND statements. Is it possible to have multiple IF(AND statements in one cell or what is the format? When I have one statement it works properly, but I cannot figure out how to have it work with two or more. I am not worried about the…
