-
Centrally Manage Drop Down Lists for Multiple Sheets
I work with a small Real Estate company and we lean heavily on Smartsheet for all of our task and workflow management. We have built a system of task lists, workflows, and meeting agendas that all work very well, but at the moment we have to edit drop-down lists manually sheet-by-sheet. I've searched the community for ways…
-
Column Header Alterations
Is there a way to alter the Column Headers? IE Bold or Sizing or Font? I haven't seen any of these options but I just want to verify that it is truly the case.
-
Is it possible to merge cells?
I need to merge cells, some within the same row, some within the same column, etc. I do not see a "merge cells" button, nor can I find the term in the community here. This is a basic requirement of a sheet, just curious where that button is hidden, and/or if it exists at all? Thanks.
-
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?
-
Graphing Data
Hello All, I am trying to build a graph of data and I was hoping someone had some ideas for me. Scenario: Multiple locations use a form to input data on incidents that occur at their location. The form has them input incident type (from a dropdown list), time of day (from a dropdown list), their location (from a dropdown…
-
Identifying current week for milestone spanning several weeks
Hi community, I'm looking for help on identifying milestone tasks that span multiple weeks (see screenshots below). Our project plans have a "weeknumber" helper that checks the END date of a milestone task to set the week number. I then use an Index/Match in the Summary Sheet area to identify the Milestone task name for…
-
Seeing user activity as an admin
I am an Admin of our account and want to see what smartsheets are owned by each user and the activity on each sheet (date/time). Logs only shows me logons. I need to verify that licensed users are really using the product. I put a ticket into support a week ago but never heard back. Hopefully I can get a response here.…
-
Links are not working from published reports
Nov 20th the ability to click on links in reports stopped working! I have submitted tickets and not a single reply or any help of any kind! Example = https://goo.gl/maps/cX1j23VBCMX1Zxde7 returns this: This site can’t be reached https’s server IP address could not be found. * Search Google for https goo maps…
-
Reports not updating accurately from linked Smartsheets
Smartsheet appears to be a little slow today in updating charts, reports, etc. and with accurate data. Wondering if this is an anomaly or if this is due to a more global impact from Cyber Monday.
-
Is There Really No Built-in Log\NL Function?
My team and I are trying to implement our escalation algorithm in smart sheet but it would seem that SS can't compute natural log in formula. Are we missing something; Why is the SS math library so dumbed down? Below is the formula in Excel we are trying to migrate. =ROUNDUP(LN(A2)/1.609437912,0)+1 WHERE: A2 is a user…