-
Ruler - alignment tool
We are only 6 months into our Smartsheet journey and thus often tinkering and creating new reports, it would be really handy to have a ruler at the top in order to align fields/columns in reports. I have marked where a ruler could sit with highlighter yellow below. Does anyone else recognise the need or have an alternative…
-
changing hyperlink text color in reports?
Some rows in our project sheets are formatted with a dark blue background and white text, however when these rows are pulled into reports it is difficult to read due to the hyperlinks provided in the reports. Is it possible to change this? I would like for the reporting hyperlink to be white for easy readability. I hope…
-
Charts & Graphs
Is this in your enhancement plan for Smartsheet? I don't find this feature like how I can create charts and graphs like in MS Excel. Thanks
-
IF Function Due Date
I am attempting to create a project status column that is using the Harvey Balls (red, yellow, green and gray). I am wanting these to automatically change yellow when my due date column is 120 days with the due date, I would like it remain yellow until a date is entered in the completed column, then I would like it to…
-
Staff Widget Production Tracking
I'm trying to set up a Smartsheet to track the weekly work completed for each staff member and for the overall team. We do invoice processing, which has about 20 different invoice types. We currently have a Smartsheet set up that tracks invoice types in rows. The columns track workload, which includes invoices processed,…
-
Restricting access to certain rows
I have a smartsheet for travel requests within an organisation of about 2000 people. Each row contains the requester's e-mail and details about date, destination cost and purpose of travel. I then use formulae to display remaining budget, etc. to approvers. Within the organisation there are about 15 people who can approve.…
-
Defining a range using a variable as the row #
Hi, Newbie question here. Let's say we have a simple SUM formula: =SUM([Column1]15:[Column4]15) Is there a way to specify the row # using a variable or some kind of reference to a number value in a cell? For example, rather than "15", something like =SUM([Column1]Row:[Column4]Row) where "Row" could be sourced from the…
-
Best "infrastructure" columns for portfolio reporting
I am wondering if someone has some advice on the best infrastructure columns to add to project sheets to enable formatting, portfolio rollups, metrics, etc. I current have automated checkbox hidden columns for parent, child, ancestors, milestones, status (based on due date). What other hidden columns do people include in…
-
Roadmap and Desired Features
Smartsheet, we need you to bring the public roadmap back. I could present a long case to justify it, however it should be sufficient to say that we need that transparency to know if often requested features will be implemented. For example, my number one (by far) desired feature is the ability to either share reports…
-
Request for generic color coding symbols
Please consider the addition of a "Generic" category of color symbols that we may attach to text/number columns for personalized categorization driven by formulas, etc. For colors, I would recommend a standard ROYGBIV plus black and gray. For symbol types, I would provide the above color scheme for circles, squares, stars…