-
How can I remove a sheet reference, so I do not receive the alert ‘Reference a total of 25000 cells
Background: 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-focused data, data that should not be managed on an International sheet that already has 85…
-
Can the Sys Admin view the overall user activity in Center of Excellence for the assigned account?
As 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 completed their modules and who has not. Do I as the Sys Admin have access to view all…
-
"Item is not currently available" error upon login
We 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 her free account or I log in with my Admin account, the first thing that happens is a…
-
Week Labeling
Hello 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, it returns LAST WEEK * if it is next week, it returns NEXT WEEK * if it is older than…
-
Is there anyway to set a cell to be both inbound and outbound?
Is 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 dates
Hi 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.... =COUNTIFS(Created:Created, >= DATE(2020, 1, 1)), <= DATE(2020, 1, 31), [Content type]:[Content…
-
Is There Really No Built-in Log\NL Function?
My 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 Excel we are trying to migrate. =ROUNDUP(LN(A2)/1.609437912,0)+1 WHERE: A2 is a user…
-
Help with a formula (match? index? vlookup? if/then?)
Hello! 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 scratch a few times a year, the easiest way to create mine is to pull the IDs of the…
-
Index / Match Multiple columns from another sheet
I 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 team information. When I add a name to the new sheet, I assign that name to a team.…
-
How to handle a very long list of (multiple select) choices in a form
I 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 teach next semester. There are hundreds of courses. I will eventually want to use this to…
