-
Sheet count
I have an individual account which allows me 10 sheets. If I decided to delete a sheet after use will that restore 1 back to my remaining sheets???
-
Identify all reports using Data Field
I need to change column header names on a sheet which is going to break reports. How can I identify all locations that the data field is used.......reports, metric, etc.?
-
Full year calendar - accounting month/quarter end
Hi All! I am at a loss at how to even start this design. I have approximately 15 tasks that occur every month on the same BUSINESS day I have another 5 tasks that occur on the same business day every quarter. I would like to see this in a calendar view Any suggestions on how to build this? ie: Formula for the 'due date'…
-
Reload does not ask to save changes!!!!! All lost
I just made a heap of changes to a sheet then had to reload as this included copying a row from another sheet I had open n another window. However, when I reloaded it lost all the changes as I had not saved not did it ask me if I wanted to save as part of the reload. Let's do it all again!
-
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…