I am pretty new to using SmartSheets and I've just figured out how to use formulas! I've been searching everywhere but I can't seem to figure out how to set a formula for an entire column. I want the formula to be automatically be applied when a new row is added (these rows are brought in via responses to a form). This column is a single-select drop down column so I'm thinking this may be having an effect?
Here's the formula I'm using (in case that may be helpful): =IF([Passed A Review?]@row = "No", "Declined")
Here's what I've already tried and all the information I currently have:
- I've dragged the cell with the formula to the others - this brought the formula to these other columns but when a new row was added via the form, these rows were added below where the formula was applied and the formula was not applied.
- I've deleted all the rows below my last one with hopes of resetting it??? - I saw this in a discussion somewhere, it didn't do anything
- I read in another discussion that once the two rows above a entered row have a formula set, the formula will automatically be set in that new row.. that hasn't worked for me either
Any suggestion? Thanks in advance!