-
Stars Value
How can I convert the 1-5 Stars Symbol into a number using one formula. I have one column Stars and the one with number should be Rating. I also don't know why they chose to have it convert in Excel to Empty, One, Two, Three, Four, Five. Why not numbers? Thanks for any help.
-
PROPER Function to change ALL CAPS to All Caps
I have a very long sheet where all text was written in upper case. I know the UPPER and LOWER functions will change the entire sentence to lower case, but is there a PROPER function (like in excel) to capitalize the first letter of the sentence with the subsequent letters in lower case?
-
Automatic email when column is "completed"
I am creating a "request sheet" for our company to use to request help in different areas. I used the web form to create the sheet and the user can get an email and those of us that are currently shared members can get an email, but I want to be able to have an automatic email sent to the "requester" when the row is…
-
formula in linked cell?
I have a "Master" sheet with incremental rows in groups of 16. So Task Name column has Row1toRow16, Row17to33 with the same headings.(SEE PIC 1) I pull info out of this sheet to other sheets. So on another sheet I just want Row1,Row17,Row34 etc entered in. (SEE PIC 2) I have the first one linked to Row1 "Master". Is there…
-
Determining top 3 items
In creating a safety sheet for my company, I am trying to determine the top 3 subcontractors with the highest number of infractions. Is there a formula that can determine the top 3, when the sheet has a format like the following: Sub x - 4 Sub y - 3 Sub z - 9 Sub w - 6 Sub v - 11 Sub t - 1 Sub u - 5 Any help would be…
-
Missing Calendar Data
Hi, I am still in the beginning stages. In calendar view, I seem to be missing some data from my sheets. One of my sheets has all data showing on calendar view, another has half and yet another has none. I assume it's something I'm doing wrong---but what exactly thanks Mike
-
Smartsheet connectivity issue with Spotfire.
Hello All, I am trying to get data into spotfire using Smartsheet.I followed the below link: http://smartsheet-platform.github.io/odbc-docs/#faq I am not able to retrieve data in Spotfire WebPlayer. The driver logs is as below. CALLER: SpotFire.Dxp.Worker.Host.exe PID_219C:TID_29D8 MODULE: C:\Program Files\Smartsheet\ODBC…
-
Certifed User
Hi I participated in the Certification program last year and was told it was only good for 1 year. What is the next step to getting re-certified? Thanks Lisa
-
New Logo Placement - Logo is tiny
Since you have moved the logo to teh left this actual logo display is way smaller and looks pretty naff. How can we keep a decent size that still makes the logo attractive and readable?
-
Quarters in fiscal years formula
Hey all, I'm trying to write a formula that will return the quarter and fiscal year (FY) of a given date. Our fiscal year is October - September. So for the first quarter, the FY doesn't match the calendar year (CY). So far I've been able to execute this for one CY, but if I try and add a second CY, I get back a blank…