How can I apply this formula to the entire column?
I can't seem to apply this formula to the entire column. it tells me that the column syntax formula isn't quite right.
=IF([Closed Date]1 = "", TODAY() - [Entry Date]1, [Closed Date]1 - [Entry Date]1)
Best Answer
-
hey @2JZGTE
With the specific row number given in your formula, you cannot use this formula, as written, in a column formula. Do you need to specifically refer to row #1, or is that just the row you are currently sitting on, and you wish row #2 to display row #2 data?
If you want the formula to cascade down the sheet and reflect the current row number for that row, you need to use the @row function. Note this is case sensitive - it is written as lower case. This function says use the current row and is the preferred way to designate row numbers.
=IF([Closed Date]@row="", TODAY()-[Entry Date]@row, [Closed Date]@row - [Entry Date]@row)
If you do need to specifically reference your row #1, let me know. There may be other ways to write the formula.
Kelly
Answers
-
hey @2JZGTE
With the specific row number given in your formula, you cannot use this formula, as written, in a column formula. Do you need to specifically refer to row #1, or is that just the row you are currently sitting on, and you wish row #2 to display row #2 data?
If you want the formula to cascade down the sheet and reflect the current row number for that row, you need to use the @row function. Note this is case sensitive - it is written as lower case. This function says use the current row and is the preferred way to designate row numbers.
=IF([Closed Date]@row="", TODAY()-[Entry Date]@row, [Closed Date]@row - [Entry Date]@row)
If you do need to specifically reference your row #1, let me know. There may be other ways to write the formula.
Kelly
-
@kelly906 Thank you for your help! It was exactly what I needed, I needed a formula that could work for the entire row on a column. Many Thanks!
-
Glad to help. You may find this article on @row useful.
Kelly
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!