Count + IF Statement?
I would like to count the days from the 'Date' to the 'Date of Completion' once entered and have the counted days in the 'Turn Around Days' column when the status column is clicked 'Complete'
Something like IF Status = complete and the Date is < or = Date of Completion then Turn Around Days are 6 (in this case)
A million dollars for the correct answer as I have no hair left.
Thank you wizards!
Best Answer
-
There's the issue. It's the primary Column which can only be text/number. Create a new Date column and assign it as a date column.
Answers
-
Try: =IF(AND(Status@row = "Complete", Date@row <= [Date of Completion]@row), [Date of Completion]@row - Date@row)
-
Hi Nic,
It says Invalid operation at the moment!
-
Pictures always help me- although not in this case! I appreciate your help.
-
Can you confirm that both of your date columns are set to Date type columns? When I switch to a text column then I also get Invalid Operation error.
Copy of my columns plus formula:
-
I can confirm this, yes. I can't change the first Date column because:
-
There's the issue. It's the primary Column which can only be text/number. Create a new Date column and assign it as a date column.
-
Your tricks work. Thanks Nic!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.8K Get Help
- 474 Global Discussions
- 202 Use Cases
- 515 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 82 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!