-
Enhancement Request - Parents as Criteria in Reports
I would like to have parents be used as filtering criteria in reports without 1. Showing the parent row which is generally useless and 2. The need for a helper column. Yes this is easily solvable with a helper column and the Parent() formula, but this is an ugly solution that fills up the sheet with more columns and more…
-
access rights
I need to give access rights only to certain people to edit a particular column in a unfiltered worksheet, All the info in the worksheet needs to be visible to all the members. Can this be done?
-
Index(Collect(Match)) Formula Error
Hello all, Hoping someone can help me, I keep getting a "#No Match" error for my formula. I have a neighboring column with top 5 orders and I am wanting to mirror the date that these top 5 occurrences happened (using a date column that already exists in my sheet). My formula is, "=INDEX(COLLECT(Date:Date,…
-
Auto-populating dates
I have several categories in my 'Status' column. (Sprint Backlog, Planning, In Progress, In Review, Changes, Print Files Ready, Print Req Sent, With Printing Services, Complete, Blocked) I would like to have a date automatically populate when the Status becomes 'In Review'. Then, once that date is populated, and if the…
-
Scheduling and Dispatching
I want a master calendar so I can see where our in house crew is working and other individuals so I may schedule them throughout multiple jobs. Now, we use individual sheets to gantt construction jobs. I want to find a calendar program (because SS does not have time stamp) were I am scheduling resources through out the…
-
Auto-push sheets or reports
Can you setup a recurring push of a sheet or report to people? I have a goals tracker that I want to send two a month to different people. Is there a way to have SmartSheet do this for me?
-
Workflow Dropdown List Options
I'm trying to create a workflow and for the Trigger Field I've got a cell that contains more then 5 options but the workflow is only showing the first 5 options is there a way to get the rest of the options to show?
-
How to update rows from a custom form...
Hi, I have a Smartsheet that contains information about different pieces of work. Each row is specific to a piece of work and it has multiple columns, one of these is Status. I display this as a Kanban using Card view. When I change the status of an item to Completed, I want to automatically send a form to a contact in one…
-
Advanced Calendar - displaying icon if comment
Hello, Recently there have been a few improvements to the advanced calendar application. However, previously, when someone left a comment in the standard comment field in Smartsheets, the advanced calendar app would display a square box on the front of the tile indicating a comment is present. This seems to have…
-
CloudFlare Blocking Issue
Hi everyone, I have trouble answering the Community Posts because I get blocked by CloudFlare. I can't see a clear pattern to why. Has something changed? I try to link to other helpful articles and similar, and it gets blocked. I remove the links. It's still blocked. I wait 30 seconds, and then it's posted. Is anyone else…
