¿Cómo encuentro el valor de auditoria diario?
Esta es mi formula:
=COUNTIFS({LAYOUT CHECK FOR DAL Range 5}, "DAL 1", {LAYOUT CHECK FOR DAL Range 6}, "Si", {LAYOUT CHECK FOR DAL Rango 2}, "14/08/20")
Cuenta si en columna 5 encuentra "DAL 1"
Cuenta si en columna 6 encuentra "Si"
Pero como hago para que busque siempre en fecha actual, es decir con alguna función today
Best Answer
-
My Spanish is pretty rusty (apologies), but looking at your formula it seems as if you may end up running into issues with how you are trying to count your dates. You are going to want to use the DATE function.
DATE(yyyy, mm, dd)
=COUNTIFS({LAYOUT CHECK FOR DAL Range 5}, "DAL 1", {LAYOUT CHECK FOR DAL Range 6}, "Si", {LAYOUT CHECK FOR DAL Rango 2}, @cell = DATE(2020, 08, 14))
Answers
-
My Spanish is pretty rusty (apologies), but looking at your formula it seems as if you may end up running into issues with how you are trying to count your dates. You are going to want to use the DATE function.
DATE(yyyy, mm, dd)
=COUNTIFS({LAYOUT CHECK FOR DAL Range 5}, "DAL 1", {LAYOUT CHECK FOR DAL Range 6}, "Si", {LAYOUT CHECK FOR DAL Rango 2}, @cell = DATE(2020, 08, 14))
-
THX Paul, my english is so bad, I will apply this advice
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.2K Get Help
- 386 Global Discussions
- 212 Industry Talk
- 445 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 292 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!