How to add a formula to a whole column

Eden

Eden ✭✭

01/24/24 in Smartsheet Basics

Hi everyone, I only know how to add formulas individually, but I don't know how to add formulas to a whole column, can you please tell me how to do it? I can copy formulas together when I copy rows to another table.Thanks!

Like this picture with fx

0 ·

Answers

Eden ✭✭

01/24/24

Already found the solution. Thanks.

0 · Share on Facebook Share on Twitter

Categories

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…

Help shape the future of Smartsheet.
Share your ideas and feature requests.