Sheets
Discussion List
-
Is there a way to pre-populate past survey responses by user?In Formulas and FunctionsI have a feedback survey(form) that users fill out a few times a week and I was wondering if there is a way to have their responses pre-load from the last time they answered. For example, say they fill out the survey three times a week and…Answered - Pending Review 11 views 1 comment 0 points Most recent by Andrée Starå Formulas and Functions
-
INDEX/COLLECT Formula for gathering list of dataIn Formulas and FunctionsHi, I am not sure if INDEX, MATCH or COLLECT will be the right things to use in this formula but I'm very much a beginner in using those functions. On Sheet 1 I have a massive list of Restaurants (Column 1: Restaurant Name). Also on that s…
-
New to Smartsheet - Setting alerts once status has changedIn Formulas and FunctionsHi all, I hope you are all doing well. I have tried to incorporate Smartsheet into my daily workings and hope you may be able to help. Seemingly, Excel is far easier when setting rules, but with automation needed I decided to use Smartshe…Accepted Answer 22 views 6 comments 0 points Most recent by Kimberly Loveless Formulas and Functions
-
Pull information from report to sheetIn Formulas and FunctionsHello, I have a template that my team uses for data collection each time we get a new lot of diagnostic tests we need to quality check. In one folder, "data collection forms" there are many sheets, as each lot gets it's own sheet…Answered - Pending Review 23 views 1 comment 0 points Most recent by Sean Morgan Formulas and Functions
-
Format as timeIn Using SmartsheetI need to keep accurate documentation of how long my deliveries take (down to the minute) I normally do this in spreadsheets by having the column formatted as a time. I cannot see that option in the formatting list. Am I blind or is it not…
-
Can you use Groups in Contact list column type?In Using SmartsheetWe have different groups created under user management, for example, email team, marketing team etc. I wanted to know if they can be used inside a column with contact list column type for a project? If yes, how? If not, what exactly is the…
-
I'm creating a form that will require hundreds of entries, how do I make this easy for the end user?In Apps, Integrations, and Add OnsI'm recreating a form that was once a multi-tab excel spreadsheet. This link will be hosted on our webpage and will require users to list up to hundreds of names. What is the most efficient way for them to do this? Should I have them attac…Answered - Pending Review 42 views 4 comments 0 points Most recent by Andrée Starå Apps, Integrations, and Add Ons
-
Formula to pull data from one sheet into a different sheet.In Formulas and FunctionsHello Smartsheets, I am building a sheet that will track an employees attendance of our monthly trainings. Sheet #1 is the raw data, Sheet #2 contains all of the formulas and combines all raw data in a legible way. See photos below. Sheet …Answered - Pending Review 23 views 1 comment 0 points Most recent by Krissia B Formulas and Functions
-
Simultaneous working on same sheet but on different rowsIn Using SmartsheetDoes smartsheet save by rows? If 2 or more smartsheet users working on different rows at the same time, how are data saved? Does smartsheet save by rows or by the sheet?
-
COUNITFS w/Ranges from Multiple Sheets?In Formulas and FunctionsHi all, I'm trying to create a COUNTIFS formula that will look for the same criteria within multiple sheets (5+ sheets at a time). I have my criteria in one sheet, and want to look across other sheets for instances of that specific criteri…Answered - Pending Review 21 views 3 comments 0 points Most recent by Genevieve P. Formulas and Functions
