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
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
Quality Assurance or Quality Control Templates
does anyone know if templates exist for either of the quality points I listed?
Print and page formatting options like excel
Hello , Has anybody done something like page brake preview in smartsheets , specially if wee need to make pdf or printouts with of sheet with rows equivalent to 100 nos . The problem i encountered in smart sheet is that we cannot split this over many pages on a A3 sheet. Smartsheet tends to split the sheet vertically…
Integration of multiple sheets into one calendar view
I need to see multiple sheet calenders into ONE clean calendar view that shows time duration (eg in minute task blocks) and colour coded by employee. I simply just need to see what each resource has allocated to them by the hours for that day, fed from across all sheets. I've seen there is an calendar-app-add on, but its…