Trending in Smartsheet Basics
-
Attendance reports
I am trying to create a sheet for attendance reports. We take daily attendance of our students, but it is done on a form which is part of a bigger report. I would like to provide the front office with a monthly report of just the students that were absent and which days. How would I do this? Hyperlink? Condition? Please…
-
Formula
Hi Community. I have what I believe is a simple formula question, but I have honestly just about everything. In short, I have a Sheet with an Assigned To Contact List column where they value may be a single person, or multiple names. I am trying to count the number of times per individual. Such as, I many time within the…
-
How can I change this Formula to leave the cell blank rather than #INVALID DATE?
Most of the other columns in my sheet only require the counting of days from a date in a different column. When the source column in the formula is not filled out the cell is blank. I am guessing it has something to do with it starting as "IFERROR". EXAMPLE OF A FORMULA THAT WORKS: =IFERROR(WORKDAY([Bldg Initial…