Is there a way to reneame the error message Smartsheet charts show ("the source data for this chart has been changed") when there is no data in the underlying report it's being driven from? I have set up my charts in such a w…
Happy faux Friday!
I'm working with a very large (about 30 columns) data sheet in Smartsheet. I'd envisioned it as the one source of truth to feed multiple reports.
The problem is the latest report I'm trying to build, the 5 columns that …
Keeping track on vacation time I need to convert dates to weeks and then again to an overview with checkboxes.
In order to get a list of weeks [c_weeks_listed] (later in use with FIND) I have come up with the following IF-formula which wor…
Formulas and Functions9HOFF
This one is baffling. I have a problem with 2 sheets reading each others data through a Vlookup. Each sheet has Vlookup ranges from the other sheet. I understand why formula and Vlookup may return a #circular or #blocked reference, but …
Formulas and Functions62scott.barrett
I'm new to smartsheet and trialing it at the moment. I have a question, I hope you can help me with:
I have a portfolio of companies in a main sheet and their debt issues, and related stuff in several sheets. Rows are companies/debt issue…
Formulas and Functions1634dlnvtl
Hello - new user here!
I have a new sheet with ~200 rows with ~25 columns. I have created a form to feed data into the sheet and that is working great. A few of those columns include creator name, department, category, and a few other 'm…
Using Smartsheet26Ben Scholz
Is there any way to automate which columns are displayed in a report based on data entered into a worksheet? I suspect the answer is no but I'd like to confirm.
I'm envisioning a scenario where I have a chart on a dashboard that displays …
Using Smartsheet17Issa M
I'm trying to build an action item report that only shows approved items that do not meet certain criteria. So in the smartsheet, there is a check box for a document attached and several columns for links to other places.
I would like…
Using Smartsheet18Jackie Callahan
Hi all, I'm having a little trouble with creating the right formula for my "at risk" / "attn" column.
(Image) I only want the column to flag is the status is not complete and the target end date is past due. My current …
Formulas and Functions22Titilope Akinlose
Is there a possibility to share just the report without providing access to the underlying sheet to key stakeholders? I know that this is possible using the dynamic view add-on but does anyone have any sort of work arounds to be able …
We use Smartsheets to manage a wide variety of projects and have leveraged the Sheet Summary feature to capture metadata (e.g. Customer, Project Sponsor, Priority, Effort, Value, PM, Start and End Dates, ...) about each of these projects t…
Formulas and Functions48Daniel Kent
Hi SS community….
One of the biggest pain points for my team and myself is the space that is wasted on dashboards. When You display reports and Dynamic calendars etc. and the lines reported in the widget do not fill the space at that momen…
Using Smartsheet35Neil Spencer
I am trying to report via a summary sheet the date that the a sheet was updated. I am wanting to report when any row on the sheet was updated not just a specific line.
I'm hoping that its something really simple that I've missed.
Formulas and Functions15Alex Maddocks
I currently am trying to automate a process but having few issues:I currently send out an email manually to send their top 3 accomplishments, top 3 issues for last week etc.
I am trying to automate the sending out email.
I want t…
Using Smartsheet35Meghana Ramesh
I am trying to build a report based on a date field. In the sheet, I can filter on and use the date field every way I need but when I try to build a report on the same sheet, that date field is not available when I come to the "What&…
Formulas and Functions15Kevin Smith
I am trying to create a form where every student is scored under the same category all at once. For instance, I have 15 students; all 15 students will be scored on 12 categories each day, with a possible score of 1-5 for each student on ea…
Using Smartsheet30Reed Vial
I'm trying to replicate the Task Rollup report that is available in the Smartsheet templates. However, for reasons I can't figure out, I'm unable to get different values for the Status column to populate the columns like the template does.…
Using Smartsheet41Cy Sack
Is there a way to roll up health of tasks underneath the parent to reflect an "average" health, if you will?
I have a formula for my children to render health, however, I can't seem to roll up to the parent. Would the same formu…
Using Smartsheet102Lauren T
I am using VLOOKUP in a sheet (call it Sheet2) to pull data from anotther sheet (Sheet1). Then, I'm creating a report that pulls data from Sheet2. This report is pulling some of the data from these VLOOKUP columns.
I'm seeing an issue whe…
Formulas and Functions43caroline_allen37286
Hello, I have a sheet that tracks donations as they are received; name, email, and amount of the donation. Some are one time donors, others are repeat donors, and I would like to create a summary page that lists each individual donor and …
Formulas and Functions23eshin35
I need to be able to roll up associated transmittal #s to 1 Transmittal and if the assessment status is Not Compliant for any of the Compliance Assessments then Transmittal 1 should equal Not Compliant, Transmittal 2 = Not Compliant, Trans…
Formulas and Functions21Jessica Larkin
I am looking to find a way that I can link (create a formula) so the health column shows a traffic light system for the status of the task.
I want to aim for this to detect the percentage of completion of a task in relation to …
Formulas and Functions570Becca Grunbaum
We have a team dashboard that is not showing correct data. It seems that the underlying report is not updating. What is wrong?
We have over 500 smart sheets for various processes. We'd like to know which smart sheets have had no activity for the day. Is there an way to create a report for this? Any ideas or suggestions would be highly appreciated.
Premium Apps and Integrations21Jayesh Kasim
I have created a sheet that tracks the training status of 20+ team members on ~200 SOPs. Each SOP has its own row and Team members are the columns. I want to draft a report or pull data into another sheet or easily sort SOPs based on Stat…
Formulas and Functions36gcuringa
Is it possible to include Conditional Formatting in a Report?
I see discussion on this topic from a few years back, wondering if there has been an update or an easy work-around to include Conditional Formatting in Reports.
Using Smartsheet587Melissa Wells
I'm wondering if there's any way to capture the actual Update Request link (what comes through in the email when you send the Update Request) in a report?
Our account people get tons of Update Requests, and don't always have the info…
Using Smartsheet32Mike Rini
I have about 80+ projects running simultaneously. In each project sheet, I have some basic project information & metrics (duration of each milestone calculated from actual start & finish dates) which needs to be tracked and ana…
Using Smartsheet38Abhiraj Joshi
(Image) Hi, I have generated my report based on resources, accounts and project status which I am trying to create a chart for but it won't accept the data from the report - any ideas?
I am trying to show a ratio on my dashboard and would like to know if I could use a function to find the ratio.
Formulas and Functions28Hattia Fitzgerald-Jones