Explore. Ask. Answer.

Find peer-to-peer information about everything Smartsheet related – from project management best practices to invaluable how-to guidance from fellow users and Smartsheet experts.

Ask a Question

creating a formula to flag a cell if 4 criteria match (two of which are dates)
I am looking to flag (during install) if the Ship & Venue Match a reference sheet as well as the Inc. Sign on Date is between the Start and End dates of reference sheet Formula page Reference page I feel like I am going to need to use =IF but also an =AND formula but I can't find the right sequence
How to convert Date and time to Pacific Standard or Pacific Daylight Time
This discussion was created from comments split from: Help to set a time column to CST time zone.
Why am I not getting the same average value in my formula compared to the sheet?
My formula shows average of .3625 (rounding up won't even help) The sheet shows average of .97 (which is correct). The values outlined in blue are MS
Is the Free Plan still available?
I have basic needs and functions that the free plan would work, but my two sheets have turned to view only. According to the following article below, I fit the Free Plan model, so why are my sheets View Only now?…
Is there a way to automatic indent rows by number? in my case with level column?
Free plan turned into view only
Hi SmartSheet community members. So I started using Smartsheet with very basic features. One sheet only with extremely basic features. Shared it with only one editor. Then after 30 days, by sheet turned into view-only mode. And there is nowhere on the app to select free plan as my features are basic and I only have one…
How to add a new row using Index/Match
Hi - I am using Index/Match to align a project intake sheet with a project scope sheet so that the same information (Project ID, Project, Project Description) show up on the scope sheet from the intake sheet. My primary is Project on both and I have the cell linked from the intake sheet to the scope sheet and then I am…
Improved PDF Exporting of Dashboards
I have created a dashboard that I would like to export to PDF to share to people that do not necessarily have Smartsheet and more importantly don't want to open links/attachments to get "quick glance" data. When I print as PDF I loose a lot of formatting and can't centre the data across the page. without customising…
Moved: Feature Request - Dashboard PDF or Printing
This discussion has been moved.
Using COUNTM Function to count more than one zipcodes listed in one cell
Good Evening All, I am collecting zipcodes in one column, a person could list more than one zipcode in a cell. I would like to total the number of zipcodes as the survey responses come in real time. Its okay if I count duplicates as well. This is a survey so I am using the text/number format. Issue: COUNTM does not count…

Ask a Question

Explore. Ask. Answer.

Categories

Popular Tags

Explore. Ask. Answer.

Discussion List

Categories

Popular Tags