-
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…
-
Enhancement Request: Report Criteria What? on Dropdown column like Text/Number
When I have a Dropdown column for the What? criteria of a Report, my only option is some version of the "is one of" criteria. What I want is to be able to build the criteria like a Text/Number column, for example using "contains" Use Case: I have a drop down list like this: Building 1 Building 2 Building 3 Building 4…
-
Calculate health of a smartsheet project.
I have created a smartsheet from a project management template. Start and Finish Dates, Durations, predecessor, % complete, are all working well. I can easily calculate the health of completed tasks by allowing a project manager to change the % complete and look at over all weighted averages of those complete tasks. That…
-
Building Reports for Widgets
In a report, I want to change the column name "sheet name" to "Project" but when I double click on the column the rename option is not available.
-
Automated Call/Text Linked to Smartsheet
I'm wanting to link a Smartsheet/report to an automated calling/texting service like Call Multiplier or Dial My Calls. Similar to how a dentist or eye center may have an automated call when you're up for your appointment. In my case, I'm developing this to work with a project schedule to get a commitment from the…
-
Three levels of detail on single calendar view
All - We have data that is organized into a Target->Category->Item hierarchy, for example: Target: Big Event in Las Vegas Category: Digital Blogs Item: Blog about XYZ There is a "Target Date" for the top level Target, and an item "Due Date" for individual items. I am trying to fashion the data in a calendar view so that…