Product questions?
Ask it here! The community's got your back.

Smartsheet Basics

Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.

Tracking Time (Tasks)
Greetings, Looking into the prospect of getting my engineers to enter time spent against tasks in addition to 'guessing' and their percentage of completion. It seems the threads here are all a couple years' old or more - wondering if there's any advancements in this arena recently. Regards, jc
Using COUNTIF to find the number of Blank Spaces
I'm trying to count how many blank spaces there are in a given column. However, whenever I put in the below formula, it just gives me the total amount of rows in the column, but the entire column is not blank: =COUNTIFS({CDVL Project Tasklist Range 4}, "") I've also tried this formula, but to the same results:…
Creating a Link in Dashboard from local drive
I have previously been able to create a link to a local drive document on a dashboard but now don't seem to have the choice. Can someone point me in the right direction please? I have the options of Google Drive; OneDrive; Box; Dropbox; Evernote; Egnyte Thanks
Cross-sheet formulas
I love that we're now able to use ranges from other sheets in formulas. I just updated a summary sheet so it uses formulas linked back to worksheets for each member of my team, rather than having the formulas on each team member's sheet and linking from there. I have a couple of questions about the best way to use the new…
Recurring Reminders
Hello and thanks for any assistance on this! I'd like the ability to set automatic recurring reminders for my clients. The ability to have a column "Follow Up" with a drop down menu showing 2 weeks, 1 month, 3 months, 6 months,etc... and then have an email sent to me every 2 weeks or whichever was selected. I'm ok with an…
delete this post
delete this post
Pasting hyperlink cell from Excel no longer working
Until today, we were able to copy a cell from Excel that had a hyperlink, and paste it into a Smartsheet cell and it would maintain the hyperlink. This has stopped working today. It pastes the text, but not the hyperlink, and this is a critical component of our workflow. We use Chrome as our browser and have never had this…
Master Schedule
We have a a master sales information sheet that imports from our sales software and then links out to individual client sheets. Each of the the client sheets links to the previous job via cell linking and predecessors, We then have a portal that includes a gantt view of a report that we look at for scheduling - see…
Sum of each different categories in on one column
Hi, I have 2 columns, one with a product description(Different products on a 1000 cells) and the other column it is their individual value. May you assist on how to get a sum of, say "shirts" only from the product description column?
Dashboard Chart Formatting
We are creating a dashboard and every time we re-select the Chart source data, the formatting of the chart reverts back. Why do we have to reformat every time? Screenshot of the chart:

Popular Tags

Trending in Smartsheet Basics

Filtering out Status based on two criteria - Not working!
Hi, I'm at a loss and could use some guidance please! I'm running a report from my project plan to see Customer Tasks Statues by Phase if status is not "Complete" or "Not Required". The Complete status don't show but the "Not Required" do. I have tried all the options (Is not blank, Is not equal to, does not contain, is…
Percent showing up in thousands
Hello, why is my 32 showing 3,200% instead of 32%
Autopopulate an email address with each new row
Hello, Community! I am trying to set up an automation that adds a specific email address to a field with the creation of each new row. It should be very straightforward but does not seem to work consistently. Trigger - when a row is added Condition - if a specific contact info field is blank {{Notify XYZ}} Action - assign…

Help shape the future of Smartsheet.
Share your ideas and feature requests.

Watch video

Smartsheet Basics

Discussion List

Categories

Popular Tags