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.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!