Unable to Convert to Column Formula?
Using the following formula but Convert to Column Formula not available, how can I update to utilize to column formula function?
=IF([Date Closed]@row <> "", [Date Closed]@row, TODAY()) - [Created Date]@row
Answers
-
Robyn,
I copied and pasted your formula into my test bed and was able to convert it to a column formula, so I'm not sure why it not working for you. A couple of quick troubleshooting questions:
- Are you right clicking in the box with the formula? When I click other boxes in that column, I get the same grayed-out result you do.
- What is your permission level on the sheet?
Hopefully this is helpful.
-
Hi @Robyn M
It looks like you had the closing if parenthesis after the today function instead of at the end of the statement.
Try this: =IF([Date Closed]@row <> "", [Date Closed]@row, TODAY() - [Created Date]@row)
Also your column must be a Date column for this to work.
Hope that helps!
BRgds,
-Ray
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!