Technology
Discussion List
-
Filter View Access for certain usersIn Using SmartsheetHi everyone, I am using Smartsheet to implement an AM (additive manufacturing) order tool for a SME, which uses AM for prototyping. Objective of that project is to directly set an order out of the CAD programm (STL-file, part specificatio…
-
Auto inputting a date based on a status changeIn Formulas and FunctionsHi, I want to set today's date in a date column when the status, in a status column on that row, is set to something other than 'open'. I don't want the date to change once it is set so the TODAY() function does not work for me. Is ther…
-
Proofing - Office DocumentsIn Using SmartsheetIs there a plan to include Office documents such as Word Docs or PowerPoints into the functionality of proofing without having to convert them to PDF for uploading them?
-
Vlookup on reportsIn Formulas and FunctionsHi I'm using a report to pull together a number of different sheets. I'm looking to do a vlookup on the report. Is this possible? If not can I select multiple sheets in one vlookup? Thanks
-
Sum Column Divided by Two Summed ColumnsIn Formulas and FunctionsThis is the formula I'm using, but I'm getting unparseable: =(SUM([Actual final door count]:[Actual final door count])) / SUM([Inspection & minor repair labor hours]:[Inspection & minor repair labor hours] + [Repair labor hours (r…
-
Is there a way to create a search box?In Formulas and FunctionsWe are wondering if anyone knows how to build a public facing sheet that has a search box where customers could type in a word or two and then have it return any hits. The data that would be searched could be linked to another sheet and th…Answered - Pending Review 979 views 11 comments 0 points Most recent by Reni Viessmann Formulas and Functions
-
Auto SaveIn Using SmartsheetI just noticed that all of my sheets are now auto saving. When did this start? Not sure if this is a good thing or bad thing.
-
Days Lapsed/Column FormulaIn Formulas and FunctionsHow do I create a Column Formula that will calculate how many days have lapsed since the "Issue Start Date"? I currently have the formula: =SUM(TODAY() - [Issue Start Date]1) but when I try to convert it to a Column Formula, it s…
-
Date updating to Next Day using Index, Match, Max, Collect FormulaIn Formulas and FunctionsHi, I'm working with two Smartsheets. (1) One sheet collects the data from a Smartsheet form. I added two columns to this sheet using the Auto-Number/System Feature (under Edit Column Properties). This features stamps new row entries wit…Answered - Pending Review 261 views 4 comments 0 points Most recent by Robin Poppsinger Formulas and Functions
-
Project planning for an Agile developmentIn Using SmartsheetHi, I would like to understand how do you prepare a project plan for an Agile software development. I understand that first the product backlog needs to be created containing the list of features/bug/enhancements that are needed for the …
