Education
Discussion List
-
How can I remove a sheet reference, so I do not receive the alert ‘Reference a total of 25000 cellsIn Formulas and FunctionsBackground: An International source Smartsheet has 1700 rows (and counting) and 85 columns. Using the Index/Match formula, we reference 14 columns of data within a new Regional Smartsheet. Why? Regions want to add additional Country-focuse…
-
Can the Sys Admin view the overall user activity in Center of Excellence for the assigned account?In Using SmartsheetAs part of the Smartsheet roll out at our company, we 'assigned' our paid license employees several Center of Excellence Training Modules/Courses with different dates to get them completed. I am the Sys Admin and trying to verify who has…
-
"Item is not currently available" error upon loginIn Using SmartsheetWe have a number of staff who are accessing Smartsheet, some as registered users under the Team plan, and many others who have free accounts and edit sheets shared with them. On one user's computer, however, whether she logs in with he…
-
Week LabelingIn Formulas and FunctionsHello everyone! Hoping I can get some assistance from the Gurus around here. Currently, we have an =IF formula that looks at the Due Date of a project and: * if the project is today, it returns THIS WEEK * if the project was last week,…
-
Is there anyway to set a cell to be both inbound and outbound?In Using SmartsheetIs there any option to set a cell to be both inbound and outbound so that regardless of which sheet I update the cell, the two sheets will be updated? Thanks in advance.
-
Countifs with datesIn Formulas and FunctionsHi I'm trying to count a criteria from one column if the date in another column is between two dates (or of a certain month). I've tried the following but formulae is not my strong point so I'm not sure what I'm doing wrong.... =COUNT…
-
Is There Really No Built-in Log\NL Function?In Archived 2017 PostsMy team and I are trying to implement our escalation algorithm in smart sheet but it would seem that SS can't compute natural log in formula. Are we missing something; Why is the SS math library so dumbed down? Below is the formula in E…
-
Help with a formula (match? index? vlookup? if/then?)In Formulas and FunctionsHello! I am looking for help in building a formula for a sheet. I create semester reports on a sub-group of persons that we track in a master database. Because this database is extensive (multiple years) but my reports are created from…
-
Index / Match Multiple columns from another sheetIn Formulas and FunctionsI tried to use index/match to reference multiple columns from a resource sheet. I can't seem to get the formula correct. My table (resource) has a list of teams with start times, parking information, notes, etc. The table includes all the …
-
How to handle a very long list of (multiple select) choices in a formIn Formulas and FunctionsI am new to Smartsheet and using it to replace old InfoPath forms. One thing I cannot find an elegant solution for is expanding fields/sections. Basically, I want to send an instructor a form that asks which courses they would like to teac…
