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 September 2016
Discussion List
include TIME in the column properties
Hi Smartsheet, Is it possible for you to add Time column property?
IF FORMULA
Hello there! I'm new to Smartsheet and I haven't found an answer to my question yet. I would like to make a symbol appear if a set of cells are not empty. In a few words, if cell A, B, C are not empty then I will have a green ball on cell D. Is it possible? How? Thank you :)
Capturing the Date and Time a Cell in Smartsheet was created or modified?
How can I capture the date and time the associate column in the above image was created and I want it to be in the date column. Thanks.
Add a task to more contacts from your contact list
Hi, Sometimes a task is not assigned to one contact. Is it possible to add (for example) the task to two contacts? Regards, Melanie
Highest Value of a Column in all Matching Rows
I am trying to find the highest value of column B among all matching values in column A. I know how to do it in Excel (see link below) but I cannot figure out how to tweak the formula to work in Smartsheet. http://stackoverflow.com/questions/21459534/excel-find-highest-value-of-a-column-in-all-matching-rows-with-screenshot
Can I highlight non-working days and holidays in report based gantt charts?
I have a report referencing several worksheets that I use primarily in gantt chart view. When I print it's gantt chart, I would like the weekends and holidays highlighted the same way they are in a worksheet based gantt chart. Is this a check box I am missing somewhere?
Feature Request: view attachment thumbnails inline of comments
I would really like the see a good sized thumbnail of the attachments I put into my comments. This will often save time from having to click on the attachment and have it open in an overlay like it currently does. Asana does a great job of doing this (see screenshot - blurred out comment and image for privacy of my…
kanban WIP limits
Hi I was playing with the Card view and wondered if there is a way to enable WIP limits. for example if I want to set a limit of 5 items that can appear under the In Progress column so that if anymore than 5 are allocated to this column the item will be highlited in red or something? Many thanks
Capturing Row History Information
Is anyone capturing row history information via the API? I'm interested in knowing how best to do this in order to understand the "history of events/actions" for a row business item. Thanks, Rick
Counting non blank cells in a row till first non blank.
I need to count blank cells in a row, left to right, till first non blank cell. the non blank cell may contain any character/s or digits. Any suggestions? For instance this formula will work to count blank cells till it finds X in row 1, columns 1-20, but not anything else: =MATCH("x", [Column1]1:[Culumn20]1, 0) - 1