How do I convert a formula to a column formula referencing cell in row above
I have written the following formula, which works for a single row, but I want to convert it to a column formula where [End Date]329 refers to the End Date in the row above
=IF(AND(CONTAINS("Milestone", [Task Name]@row), ([End Date]329 > ([End Date]@row + 1))), 1, 0)
Answers

Hi @LeanneKvZ
Column formulas cannot be dynamic. It can reference a single cell (i.e. fixed reference like [End Date]$329) or a cell at the row ([End Date]@row).
Thanks,
Aravind GP Principal Consultant
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.8K Get Help
 410 Global Discussions
 219 Industry Talk
 457 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!