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.

 

Sort Hot ▾

• Hot
• Top
• New

Discussion List

• Importing excel IF/And statments to Smartsheets

  I use the below IF/AND statement in excel. It works fine. =IF(O4="Close","",IF(D4="","",IF(AND(M4>0,M4<=0.1),"YELLOW",IF(AND(M4<=0,M4>-0.1),"GREEN",IF(M4<-0.1,"PURPLE",IF(M4>0.1,"RED",)))))) When I im…

  

  Manufacturing

  Project Management

  Smartsheet Basics

  281

  Jul 8, 2019

  4

• nested substitute

  How can I use substitute to replace not only one but multiple letters? For eg: -0.-9 I want to get 09 only.

  

  Smartsheet Basics

  1178

  Jul 8, 2019

  5

• Search for Hyperlink

  Is there any way to search a sheet for a URL, if it is included in a hyperlink? The URL does not appear on the sheet, the text for the hyperlink does instead. I tried searching, given a URL, and its n…

  

  Search

  Sheets

  Smartsheet Basics

  221

  Jul 8, 2019

  1

• Date problem

  I recently ran into a problem with dates that were hard "mm/dd/yy" coded into a formula and populated in a date field. For read only purposes, this is fine, but it becomes a problem if you try to use …

  

  Smartsheet Basics

  121

  Jul 8, 2019

  1

• Japanese text gets garbled when exported into PDF/PNG.

  Hi please check the attached. I put some text in Japanese and tried to export the whole gantt into PDF/PNG. But what I see is the garbled texts for Japanese. I think this is a bug; can you fix this as…

  

  Project Management

  Smartsheet Basics

  151

  Jul 8, 2019

  3

• Formatting the Custom Message in an Alert

  I would like to send an alert to each of my team members weekly at 2:00 pm on Thursdays. I created the form, and copied the URL. I created the Automated Workflow to send an alert to my team members, a…

  

  Forms

  Sheets

  Update Requests

  Smartsheet Basics

  1204

  Jul 7, 2019

  1

• Creating % complete for each parent row?

  Hello! I'd like to show the % complete of each of these training modules on the associated parent rows. I've attached a screenshot. Happy to add/remove columns, etc... Can someone please assist?

  

  Smartsheet Basics

  301

  Jul 7, 2019

  9

• Puzzled

  I put a discussion out there, acknowledged by the increased badges that I received, but I find my inquiry missing for the past 24 hours. I have not received a message telling me that the information t…

  

  Healthcare

  Conditional Formatting

  Smartsheet Basics

  131

  Jul 6, 2019

  3

• Forms

  Is there a way to be able to create a radio button question that will allow you to select more than one answer? I have selected the radio button vertical view but I need the audience to be able to sel…

  

  Forms

  Smartsheet Basics

  161

  Jul 5, 2019

  1

• Smartsheet work map

  Does anyone know what happened to the smartsheet workmap, that beautifully displayed all of your sheets and users in a 3D space? It helpfully also highlighted users outside your domain. I tried the li…

  

  Smartsheet Basics

  222

  Jul 5, 2019

  2