-
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
-
Countifs same column different criteria
Hi I'm trying to count the items in the in one column if they are not equal to criteria in another column. May someone assist. This is what I have so far. =COUNTIFS({FDA Submission 2019 Range 1}, "DE Novo", {FDA Submission 2019 Range 2}, OR(@cell <> "Approved", @cell <> "Rejected", @cell <> "Withdrawn")) However everything…
-
Tab options in One Sheet
Good Afternoon! I was curious to know if SS offered something similar to Excels "Sheet Tabs". For Example, instead of jumping back and forth to different Smartsheets, is it possible to jump back and forth without ever really leaving the page you're working on ? Please see the attached file for a better understanding of my…