I'm attempting to create a formula that will count the number of cells in a column from range in another sheet, that only includes the cells with a checked box.


In other words, there are two columns to include in the count from my Communication Tracker sheet:

Done -- checkbox column




Hi everyone!

Im having issues with a status column. My goal is to update the status if a job has hit 10 days or more and has not been approved yet. I was going to trigger it by using the (system column) "Last Modified" 

Here's the problem: If someone only "views" the sheet & doesn't make any

Christopher D Thrasher


Hello All, I am trying to build a graph of data and I was hoping someone had some ideas for me.

Scenario:  Multiple locations use a form to input data on incidents that occur at their location. The form has them input incident type (from a dropdown list), time of day (from a dropdown list), their




I have been asked to create a roster that covers customer support across different time zones and shows who is available (human resources),  who is on leave, time, names of the support person and who is on call.

Also, includes our contractual obligations with customers in an easy display


Nov 20th the ability to click on links in reports stopped working! I have submitted tickets and not a single reply or any help of any kind! 


Example = https://goo.gl/maps/cX1j23VBCMX1Zxde7 returns this: 

This site can’t be reached

https’s server IP address could not be found.


  • Search Google for


We currently use Jotform for some of our forms here and would like to be able to bring more of them over to Smartsheet if possible

As you can see from the attached files, the form is set up to add a new line after each previous line is filled in and the 'save' button pressed

Are we able to set up a