-
"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…
-
Validate if the Hyperlinks in the cell are a valid URL's
Hi, i am wondering if there's a way to validate any External URL to check if it is a valid URL with a status 200. Any help is highly appreciated. Thanks
-
Smartsheet calendar fail to sync with Google Calendar
Hi Community, I'm a smartsheet beginner and hoping I can get some help here. When I follow the steps to publish a smartsheet calendar to Google calendar, the process seems smooth without any trouble. But somehow when I check my google calendar, there is just nothing. The smartsheet calendar didn't appear on the Google…
