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
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!