Count days based on delay reason
Hi,
I'm trying to calculate "delay in days" based on "delay reason" and add a condition when the delay reason is "scope" it shouldn't calculate as its delay(as per screenshot is 5 days (subtract)) , can anyone help me with the formula?
Answers
-
It would be helpful to know more information about your specific sheet and set-up before we can help create a formula.
Where are the "days" coming from? What are we comparing, to get the number?
For example, do you have an "Due Date" column with a date in it, or a "Finish" date column, and are we comparing that to if the status is "Complete" and today's date? Or do you have another way of tracking with a row is due?
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!