-
Dashboard Chart Displaying Currency for Viewer
Hi Smartsheet community, As an Admin, I setup a dashboard with a chart showing data with $ signs. A viewer sees the same dashboard chart with US$ signs. Is there a way for the viewer to see only $? Thanks for any suggestions! Dee
-
Processing Limitations: List of formulas in order by relative processing power required?
Hey Community! One of my first requests. I dug around and so far haven't found anything, but my apologies in advance if this has been addressed elsewhere. My company has been bouncing off sheet limitations for a bit now, yet none of our sheets are anywhere near 10,000 rows (I separate into logical volumes as often as…
-
Feature Request-Bullets in Cells
I am sure this has come up before, but I couldn't find it in a search for bullets. I am trying to use Smartsheet for proposals and it would be so helpful to be able to format a long list of items with bullets. I realize I can create them with bullets in a text editor and paste them in, but it would be much easier to work…
-
Clean up Sumif Formula
I have this formula to give me the sumif for multiple criteria I was just wondering if there is a simpler formula =SUMIF(@{Healtcare Range 3}, @cell = "Memberships", {Healtcare Range 2}) + SUMIF(@{Healtcare Range 3}, @cell = "Sponsorships", {Healtcare Range 2}) + SUMIF(@{Healtcare Range 3}, @cell = "Client Seminars /…
-
Countif Query
Hi, I currently have the following formula which is used for counting how many jobs we intend to complete on a day: =COUNTIF({Realistic Completion Date 4}, {Realistic Completion Date 4} = TODAY()) This works fine, although there is a scenario where we often add things to the job, which is identified by a letter A in the…
-
Project intake
Hi For our project- and programmanagement, we want to make use of the template set 'project intake'. We already created an 'intake form' whereby projectleaders can submit their project proposals. Is it possible to share this form with possible projectleaders without giving them acces to the project intake sheet in which…
-
Latest Discussion comment viewed in a cell
I would like to request that the most recent comment in the discussion function be able to be mirrored in a cell in that same row. This would allow us to quickly scan a sheet full of data and see what the latest comment is without switching views.
-
Export to MS Project
Hi, When I export a sheet with a Gantt chart to MS Project, I loose all the data on task duration, dates, predecessors, etc. Is there a way to export keeping this project information intact? Thanks, David
-
MacOS and Firefox - Gantt Scrolling Not Working
I have a MacbookPro 2017 and I am only using the built-in trackpad. No extra drivers for Logitech or any other input devices. When using the latest version of Firefox, it takes 2 or 3 tries to get the Gantt to scroll horizontally or vertically. And when it scrolls, it is very jerky and slow. I have the exact same browser…
-
Future Date Calculation
Hi I'm trying to convert an Excel formula to Smartsheet formula: Excel formula =[Installation date]4+(365*[Warranty Expiry]$3) Aim is to give a future date when the warranty will expire x years after the piece was installed. Thanks