Sheets
Discussion List
-
Looking for a way to auto fill the Label and Description on a formIn Using SmartsheetIs there a way to quickly customize label and descriptions on forms? Like for example reference the field that contains the label and description information so it populates based on the primary value. Example I'm using the form as a votin…
-
Trying to identify cells in ALL CAPS vs Title CapsIn Formulas and FunctionsI have a sheet where I've pulled a list of titles that exist on a series of URLs in either all caps or title case. I need to be able to identify or sort by the lines that are in all caps so that they can be corrected - is this possible?
-
Project Schedule Baseline - Is History Kept when Re-baselined?In Using SmartsheetWe are using the Project Schedule Baseline functionality, but recently learned that the Schedule can be Reset or Removed. Is there anyway to track how many times a Schedule has been 'Reset' or 'Removed' and baselined again? Our concern…
-
Formulas Question - Referencing Another SheetIn Formulas and FunctionsGood morning, I am trying to pull calculate an average from data being pulled from another sheet. I want to be able to calculate the average duration, by month of completed projects. I basically want to say what is the average of the durat…Answered - Pending Review 13 views 1 comment 0 points Most recent by Paul Newcome Formulas and Functions
-
Using CountIfs to track a column will multiple optionsIn Formulas and FunctionsHi everyone I have a multi select column that I am trying to use a countifs statement to count of instances of a name. However it only returns cells where only the name exist and nothing else. Does anyone know how to make it that it counts…
-
Pulling data from another sheet (vlookup?)In Formulas and FunctionsHello, I have a question about pulling data from another sheet and I'm hoping there is an easy way to do this. So I have 2 sheets, one is my main sheet with all my data (collected via form), and another sheet is my roster. On my main shee…
-
How do I have 2 owners for a sheet? What if someone deletes some data & team needs to recover dataIn Using SmartsheetIs is possible to have 2 owner for a single sheet. What if someone deletes some column/row from the sheet and there is no way to get the version history or restore the data, if the only 1 listed owner is there but on leave. How do we get t…
-
Work Breakdown Structure (WBS) - Column Formula ConfigurationIn Best PracticeHello Everyone, Recently myself and two fellow Smartsheet Sales Engineers, @Lea Gikas and @Dave Stanley got together to create a WBS solution powered by Column Formulas. We wanted to provide the resulting configuration to the community in…
-
Freeze Column issueIn Using SmartsheetGood afternoon, We have a Freeze set to maintain the view of a certain columns that are referred to throughout the day. However, the freeze doesn't actually work as expected, as almost every time I go into our sheet the pane has been moved…