Kelsey H’s Profile

Community member since July 2017



I've been trying to update a dashboard to include the new Web Content widget since I find managing some data and charts in Google Sheets far easier than in Smartsheet especially when collaborating on the data / file.

I've followed along with the instructions for the Google chart I've created.


On a sheet I call "Project Group Hour Totals", I am trying to add the hours from a sheet I call "Project Time Tracker", using VLOOKUP to find both my Project Category and my Project group.  My Project Time Tracker Range 1  is the hours column on the project time tracker, and Range 2 includes 6


The new dashboard feature for Smartsheet says we can embed power BI reports by publishing to web, but doing that in Power BI makes your report public to everyone. How can I embed while still mainting privacy as these reports have company information?

There is a Power BI option that allows you to


I am trying to put together a formula to automatically change the RYG harvey balls based on the end date(due date) and the completion status of the empty/quarter/half/three quater/full harvey balls? I was hoping to get some help putting the nested if statement together.

Here are the conditions I am