-
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…
-
Automating RYG balls to change colors
So i have parent cells and dependencies. The dependencies have color balls (red, yellow, green, grey). Here is what I want: If one of the dependencies has a red color ball, I want the parent ball color to be red. If all dependencies have a green ball, I want the ball for the parent to be green If all dependencies have a…
