Sheets
Discussion List
-
Vacation & Time-Off ManagementIn Using SmartsheetHas anyone used smartsheet to manage time-off requests and/or vacation for a pool of staff (approx. 200)?
-
Cross Sheet Joining AutomationIn Formulas and FunctionsHello Community, I am attempting to make a few helper sheets try to consolidate information into one row. Background: I have multiple sheets that have hundreds of parts/items from a range of vendors. I am hoping to implement a checkbox th…
-
Using Index with Collect to Copy information from one sheet to another sheet for an entire columnIn Formulas and FunctionsHello, I have 2 existing SmartSheets: Sheet 1: A Master sheet with 2 columns: Sheet 2: Another Sheet where only the "Die Name" where "Is Die 1 New?" = "true" is captured. I have tried the following formula u…
-
Shared filter not working for other usesIn Using SmartsheetHi, I have created a shared filter on the Smartsheet sheet so that people can see certain projects only, and with the other projects being hidden. The filters hides the other projects on my sheet however it does not automatically hide them…
-
How to change first week number from Jan 1 to July 3 ?In Formulas and FunctionsHow to change first week number from Jan 1 to July 3 ?
-
Frozen/Unresponsive SheetsIn Using SmartsheetWe're experiencing freezing/unresponsive sheets after a few moments of being open. This has been going on for a few days. Anyone else experiencing this? Thanks
-
Workaround for Sheet Reference Limit?In Using SmartsheetHi everyone, On our project we have two sheets, a project plan which contains around 50 items, each containing around 9 sublevel actions. We have a separate sheet that we were manually maintaining in excel containing all of these sublevel …
-
How to create children in large sheet automaticallyIn Formulas and FunctionsHi! I'm new to SmartSheet and not very good with Excel 😪. I have a sheet with over 18,000 rows that I would like to make any cell in the primary column with a date a parent of the rows beneath. I used an excel formula to find and add th…
-
SUMIF Formula Not Working for column with #'s but working with text..In Formulas and FunctionsMy sumif formula is not working with a numeric value but it is working on a text value.. Here is my formula that is not working: Sheet Referencing: SAP WBSE is the same as Proj. Def. column. I'm asking it to return the Ovr Commit column…
-
Filter for contents starting with a 2 or a 6 is no longer workingIn Using SmartsheetSearching using Unnamed Filter with "contains" starting with the number 2 or number 6 is no longer is working
