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),
I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific locations (we do not know these specific locations until last minute).
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:
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
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
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
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
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