I need to project out 14 days from a given date based on an affirmative answer in another column.

Options
Storme Dunn
Storme Dunn ✭✭✭
edited 04/01/20 in Formulas and Functions

So if the answer in Status is "Sick" I need to calculate EACH of the dates for the next 14 days from FIRST. And then I need to add up all of the entries for each of those dates. So if I have 5 people out today, I need to report back 5 for today.

data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAMYAAAEkCAYAAAB0YE5gAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAABuJSURBVHhe7Z1frBXVvcfXuTXltPE2pWivFzGoUNMm9aEWsNyEVl4KD8TWYAy+GOgDCSAPtV4klRhjSo2gkrQKCU0K8UGIKbFteEBeTIvBK7S2hiY2t+Cf9JS/2tZQ/hi4evdnnfmds846v9lnn7Nn79kevp9kMrPWzKw9e+b3Xeu35s/69Z09e/bjIISIXL58OZw7dy70nTlzRsIQouCjjz4Kly5dCn1HjhyRMITI6BsYGHCF8Y9//CNMnTq1SIlOM2NLf7Ek6mLg+xeLpRD+rZgLIRIkDCEc5Er1COZKpc256B6cf7lSQoyBhCGEg4QhhIOEIYSDhCGEg4QhhIOEIYSDhCGEg4QhhIOEIYSDhCGEg4QhhIOEIYSDhCGEg4QhhIOEIYSDhDGJ2b17d9ixY0eREuOhsi/4fvvb34YDBw6Ev/zlLzF9/fXXhwULFoTFixfHtGjOeL/g27hx49C5zvnSl74UHn744fDkk0/G68i2ojn5F3yVCGPfvn2xdvrqV78a5s2bFz7zmc+EP/3pT+E3v/lNTK9evTpud/jw4fDss8+GNWvWhLlz58a8VrGLywWfjExEGOfPnw/f/e53i5xhOP9ciypZvnx5rOSWLVtW5EwuOvJp6/79+2ML8eCDD4ZvfvOb0ehXrFgRT+ShQ4eiSET1fPazn43nOp+qFsWVSCUtBrWJNd8pCOJXv/pVdKl+/vOfF7nD7Ny5M85pSRCXuQZcWETFnJaIFinFai7vd71W6Ze//GV09f7+97/H2vTWW2+N+3/hC1+I63uBibQY0KwFzbex9PTp02NrbufxnXfeCb/4xS+GKjAquUWLFsVKjn1yl20iLX6v05EWA3eJk4cRY3wGhs1F4QRzMq3ZZ04auBgY8pQpU2Le9773vXDs2LEhIX3jG9+I+VwsJpbJaxVEhTA4Rvblgh85ciRs27at2OLKgut0/PjxKIpZs2bFvJ/85CexIuTcc45oiTj/VDLf+c53Yh7YObT9JjOVCINa51vf+lY0wgceeCDWMhhjKhJqGAwbmFuNQ00OuGHkISIuBvtyYW688caYz8Uy14G8Vvn9738fWwaOkX0RJeKYDGDktJrpZK1CGZwLKis7H5xjzjWturnBq1atii3x+++/Hys38mxflnuppe0UlQiDE0Wf4tFHH401EZ1ChMEFyN2gHDrm5lIZ06ZNK5ba5+tf/3q88Fu3bh1ypxBHMxfkk4K1oOlEpdKM/NyaoePKcs1owU08XMsrlUqfY1CTUxNRayESTjDuFT5sM9iGC2G1Hq5VVXBxcRFwFXAPrEWbDDcEvM73RDreGzZsCLNnz44VB7d4aTG4JlcybQsDA/MMDZFYn+KPf/xjnHvwAIqOIE057hStBzVfK9CRbgVcBIRH2YiEFq1K8X3SoQKj5X766adjhWZuMS3IlUrbwrj66qujr2t9hZQLFy7EeX9/+UjedARnzJgRa3ar7Wy/sWA/jDwFvziF2g83ykAk3JXiNyZDq9EuGD+ttLXq1urD0aNH4/xKpG1hcCKpYXheQTOMQOjQccJ37doV/WDuZoDV8Kw3IXFLGGHRcpDHnP1yuGs1MDAQtzGD5u7I3/72t9jsUyb7cns4xY7NtmF/7kpRS07E7ZhsUFFwXX72s58NXTtzo9LzwzacN9aP5RpPBj7V8LkfLZZHcPHixZZdla997WvR0DDSl156KZ6806dPh6985Sth5cqVcR188YtfjL7+wYMHw5///OewZMmSaNzk/eEPf4j7ffrTnw4LFy6Mxo+ovvzlL8d9P/e5z8U89qUc8rkfz764Yrbv/PnzY9mIkf25uPwXxMGF53dmzpwZbxZ8/vOfj2X3Ak//z1Vx/sD8y3E+Frx+Axh2Gfk23j5cYyq39Npxg4I7d1wf46qrroouMed/zpw58RpMJjj/6bnXaOc9wngf8Ilq6cgDPiEmGxKGEA4ShhAOEoYQDhKGEA4ShhAOEoYQDhKGEA4ShhAOEoYQDhKGEA4ShhAOEoYQDhKGEA4ShhAOEoYQDhKGEA59J0+edL/g++c//9lTn35Odq7bPPhp68n/bu3TVlEtnP/03PcdOXLEFYboLrfu/M84P7L8RJyL7sL5T89939mzZ11hMBIEH8mL7vDvj34Y52cfnRLnortw/tNzrz6GEA4ShhAOEoYQDhKGEA4ShhAOEoYQDhKGEA4ShhAOEoYQDhKGEA4ShhAOEoYQDhKGEA4ShhAOEoYQDhKGEA4ShhAOEoYQDqWDIYjuosEQ6mXUYAgHDx6UMHqA/9pzS5wfXPq/cS66C+c/Pfd9Hzcolof48MMPw3vvvReuv/76Ikd0mr4H34/zM+tVT3Wbjz76KPzHpk+Fj5+cVuSojyGEi4QhhIOEIYSDhCGEg4QhhIOEIYSDhCGEQyXCeOutt0JfX9+oKWfx4sVh9uzZRWpsNm3a5JYjhlm3bl245557itRI5s6dG6699tqh6ac//WmxZiTvvvtuXG+wXbof5Xi8+OKLI7YrOw62K1vHfqz3YJ+0fI6zW7QtjN27d4dZs2aFXbt2BZ4V2rRq1apo1K+88kqxZQj79u0LR48eLVKiXTDgHTt2FKmRYEg33XRTOHPmTJx+97vfhcceeywKKef1118PK1asiMusZzu2t30ph/JS+O2VK1eO2O7ll192BfDqq6+Ge++9t0gNUyY4YB3lWdnbt28Pc+bMCa+99lqxRWdpWxgbNmyIIli2bFmRM8jWrVujYJ5//vkiR1QJhoMBe1gNvHnz5jiHmTNnhkceeSQKKa95Mdz58+fHZdazHdsbVo61OOzPb2Os6XakMea8fPJuu+22IhWicSM0Qk14cPys27t3b5ETwl133RXFe//99xc5naUyV8qD1gGBGJ4rZe6STaSbQRmtbDeZoVbGcKhJvRgmGBHrUqOFGTNmFEsjQQzsA+y3du3auGzk5fz617+Oc9vH8H4XEdDiWB6iWbJkSTTy1PBTECrcfvvtcW4gXv53N1yqtoXx7W9/O7z00kvRWMsEUsbq1avDQw89FI4dOxbdL+aky4weUfBbbOe5BFcKL7zwQjTA8WIGlxvuwoULi5SPuS8mrL/+9a9xHwzU/H8m75ocOnQoLFiwoEgN/jbH3k7FdvLkyWKpc7QtDFoEXCnAdbKaH6NvBiLatm1b7JvcfPPNMY/5E088EcWRk4rCthetg3HTMlhfwtizZ88Iw/Uw98VaCGrtt99+O/r8GDkTfQ3Kz/sYzz33XJg3b16Rag1z6/KWwYTdDSpxpRCHdboRB2D0CCTtfKdQk0B+0qh1KCfFRJGKSLSOuS+4XXlNjf9/5513FqnRmNuWuz15Hi2B9TGshTHDzl2isUCAHOvdd99d5AwLu1tUIowU+hXmFsHy5cvjvB0QBYLz7myI5mBQ1OwY2uHDh4vcQcxwU9cqxe4MIQDPuPM862AfP348zrnbNZabVoYdq7lpTz31VGmfpBO0JQxu1Za1CuYWmUDagTL2798fl8dy0cQw3N2hpcA4c1EAnej77ruvSI0EY6RVwEXKBTCW62XQwi9durRIjR+O2Vw1+lUmuPG2QBOhLWHYLdqDBw/GeQ4n1lyrHHOhzKUyTGxpRx6RmdBw0crcMzEMouA5A6LAqDwOHDjg+v+IAhCF15rYPvmDOVoIsJaD1mYiRky5HEPex0BoE22BxkvbrpR1lvOaHF8WI/7Rj35U5IwEQ6fTjnuUioA0+V5fgv4HQqvCPZvMYFBjiQI8w7XOc5kogH0om98w47XfpHPPfrhwEzVi6+Q/++yzcQ48Q+F402cznaRtYWCsuDrW2bYJsdDXyB/8pdBpR1jp3SxEkT77yNm5c2f8PTrkwscMCkMyHz2dqJGZ8jtUGDP7AP2SfL/0jhOC40GgbcectHXuudvVTp8Q94nOtv02DxTJKxNr1eib7x5B33zXh775FqJFJAwhHCQMIRwkjBp54403wqVLl4qU6CZvvvlmuHy5fNRHCaNGNm7cGNavXx/OnTtX5Ihuwe3fxx9/PJw/f77IGYmEUTO8qVr2rEd0lhMnTkSBfPDBB0XOMBJGD8AFEvVw+vTpcOHChSI1jIRRM9OmTQs//OEPi5ToJlOnTg1r1qwJ1113XZEzjIRRIzwZ3rJlS7jllsGRzkX34FV7ntR7rx5B38WLF0c9auVOCX7XNddcU+SITtP/8L/i/NS6/4tz0T14+YP4GBc3Xl3kNIQxMDCgdxB6gBlb+uN84PsX41x0F85/eu71rlSPoHel6kPvSgnRIhKGEA4ShhAOEoYQDhKGEA4ShhAOEoYQDpUIg1E+0oEQbMphAAPFx6gGBkOzgQKYPPJtbLTyHEb4KCuDARDKxgkmPy3fRiDMYeCFdCAFltP92i2/E7QtDMXH6D4YfBr7gtE+MJwU0hOJj5HCtjZqSA7GzSgelEv5jBLI4G75WFOQxsfg2Bn31o6LyRvzlt8m37Zh+E/K75Y42haG4mN0FwyPgezS8ZVoWRmC01oEM86JxMcwEBbbetgwO2l8DMaaonzGlsphWwZhYz+O/ZlnninWDOKNectvk28w1hTiZajOblCZK+Wh+BjVgxEjgnx8JQY3Y2Rx8OJUQCvxMYBand+gDA8bPTINBgM2QmFaq7Ns8TEQD2Xmg7xNnz69WBokH9HQQLwIKBd2J2hbGIqP0V2ocTG0nBtuuCGua0ar8TEYM9Yb67ZVbIxZyONjeJjQ7LuIgYGBOM+FbQJSfIyEVBRl79BfCeCfTwQEQMuQ9yVaiY+RYy1DbqD5OMQwVnwMan/6PojThMDnvnVTiSuFOKzTjThA8TF6B4xvovExPGzsWso0zMBTzOXJXacUhvaEZmPs1kElwkhRfIzO4rlRzaClmGh8jGZgyIjDbqUS5IU7VCnN4mPw23YnLe/L4BbWTVvCUHyM7oOBe+4U7gfrUrg7NdH4GK2AODBqJso318o6zWXxMVKxeh18u0lgwjWs7+J9o101bQlD8TG6T1nkUlyitHZGFBONjzEWGDa1PfMU+isYu7VAHFPuRrGPuXVlHXwTlt2dMsruyHWCtl0pxcfoLl58Os4LYrH+A6KZaHyMVmAfjiF9poAQ6dzbMwoE4LlRY4kCMHxuEqTxN/LyO03bwuCi4OooPkb3MKMy/x6DSV2SicbHGA8cAy6dlYkR08cwoXnxMewBJCJOj8em9JUVRM7xWfwNyi+LBdgJ9M13j6BvvutD33wL0SIShhAOEoYQDhKGEA4SRo0ocEx9KHBMD6PAMfXBrWEFjulhFDimPhQ4psdR4Jj6UOCYHkWBY+qjWeAYxceoEd5u5QvI/v5+xcfoMnzKcMcdd4QpU6bEV5cUH6NHUXyMelF8jB5F70rVh96VEqJFJAwhHCQMIRwkDCEcJAwhHCQMIRwkDCEcKhEGo3ykAyHYlMMABoqPUQ2djI/Bdul+lNMMG04nH9LHYOAFxccoJkb7wKgVH6N6MNROxcdgPdtZ3AsmysnLNxBDOlSnh+JjJDAEDoJRfIxqofZl+JlOxcdgPdulg5pZOXmLQ9rGnm0Gw/goPkaC4mNUT6fjY7Df2rVr47KRlwOIj5YF40VIZWDstDiUwZhQlJ+PDaX4GBmKjzF+qHG9gZ2rjI+RYzV5KiwTnwmqDMXHaJCOKKj4GJ2hjvgY999/f5yPJQIPxccoOt2IAxQfo3ewDjIuWN4a45o0i49Bp5iWiOExx4u5PM2G1VR8jDZAFAhO8TG6Gx+DO0gIZ6Jjxio+huJjdA0MvBvxMTBaWop0oObxovgYio/RNboRH8NqckRR1pq0AseUiwpRjBUKQPExGp12xccYH3SAMY5OxcewB23tigIBeG7UWKIAfpebBIqPkdzNQhTps48cxcfoXHwMjJl9wOJSpFP+dLoZio8hKkHffNeHvvkWokUkDCEcJAwhHCQMIRwkjBpRfIz6UHyMHkbxMeqDW8OKj9HDKD5GfSg+Ro+j+Bj1ofgYPYriY9SH4mP0KIqPUR98yqD4GJ8AFB+jXhQfo0fRu1L1oXelhGgRCUMIBwlDCAcJQwgHCUMIBwlDCAcJQwiHSoTBKB/pQAg25TCAgeJjVEMe+8KDgSrSbRgAwSMd/CyHARAox4MX8Fopn/x0IAWW0/3Kys+Pn8EaukXbwlB8jO7TSnwMjMpGD2FihA1G2khH4jDS+BgplGGjhuRQThpHw8r3xKH4GAkMgYNgFB+jWjA8hp9pFh+DFgCjSuNLMOwMxm+hAlLS+BgGQqOMMhBFGkeD8kn/+Mc/jukUxKX4GAmKj1E9rcTHYB21bKujk2OE6bbU6vwGZXiYAeejGJLG8NNanWXFxygRSBmKjzF+MLyJxMegpUEA+SvuGG4+YiADujUbKbBsDFlL23pQfIwG6YiCio/RGcYbHwNB4BbZkJ15K9JKfIwcM9xWUHyMotONOEDxMXoDhGAdWMg76bgmzeJjtIO5PM2G1VR8jDZAFAhO8THGHx8jJQ8yaYabuyxjURbLL0fxMRQfo2vQKW41PsZYNIuP0YwyX9/Stl7xMRQfo2u0Eh8Dw6M2Tu8OgRmuGV5ZfIyxMNcov3aWtvUcU+5GcUyKj6H4GJVDnwHjaBYfA2NEJBiggZBIpx1wz3BbhWcWdJpNfMxJ27MH0p4b9UmJj0F/YBQMkMC34K3ScHXoLY+achYtWvRxw7CL1CANYY3YpyGKYs3wupRGLRfzKGsyEX7wXpwarkVLU8O4Rpw3b5uGcY3YhrStaxjwiHTZlO+XTg1xjCifMm0d+6Rpb/t8Yn26fX78e/fuHbG+qunUqVPx3Kfom+8eQd9814e++RaiRSQMIRwkDCEcJAwhHCSMGlF8jPpQfIweRvEx6oPXYhQfo4dRfIz6UHyMHkfxMepD8TF6FMXHqI9m8TEkjBrhvbAtW7aEW265pcgR3YJvUHjfy3snDxQ4pkdQ4Jj64K0oBY7pURQ4pl4UOKZH0UuE9aGXCIVoEQlDCAcJQwgHCUMIBwlDCAcJQwiHSoTBKB82NGc65XiDOjeDUS+8coTiY3SatoWh+BjdR/ExOk/bwlB8jO6C4TGGlOJjdJbKXCkPxceoHsXHUHyMUaShAMr80skOhqf4GIqPMUQqirJXha8EFB+jO1TiSik+Ru+CEKwDC3knHddE8TFGU4kwUhQfo7MoPkZ3aEsYio/RfegUKz6G4mNEEJkJTfExFB9jvC3cRGjblbLOsuJjdAf6DBiH4mN0mEZ/YBSKj9F9FB9D8TGEgz5trQ992ipEi0gYQjhIGEI4SBhCOEgYQjhIGEI4SBhCOEgYQjhIGEI4SBhCOEgYQjhIGEI4SBhCOEgYQjhIGEI4SBhCOEgYQjhIGEI4SBhCOEgYQjhIGEI4SBhCOEgYQjhIGEI4SBhCOEgYNfLGG2+ES5cuFSnRTd58881w+fLlIjUaCaNGNm7cGNavXx/OnTtX5IhuQYyQxx9/PJw/f77IGYmEUTPEtSgbEV50lhMnTkSBfPDBB0XOMBJGD8AFEvVw+vTpcOHChSI1jIRRM9OmTRsVSVV0h6lTp4Y1a9a4EZr6iIVRLA9Bh5Dm5ZprrilyRCcg1BfhoPv7+0P/w/+KeafW/V+ci85CXMc77rgjTJkyJcaMvG7zVeHixquLtQ1hECCmWBY1MmNLf5wPfP9inIvuwvlPz70Cx/QIChxTHwocI0SLSBhCOEgYQjhIGEI4SBhCOEgYQjhIGEI4VCKMt956K/T19Y2achYvXhxmz55dpMZm06ZNbjkihLlz54Zrr712aPJYt27diG1efPHFYs1I3n333dIy7rnnnliOR1p2s/LJpxyD5XS/svLz43/ttdeKNZ2nbWHs3r07zJo1K+zatSs+Wrdp1apV0ahfeeWVYssQ9u3bF44ePVqkxERBFDfddFM4c+ZMnFasWBENJwWj2rFjx9A2e/fuDStXroxvk+a8/vrrsYwcynj55ZeL1DAmJPZppfxXX3013HvvvXGZY3/77beH9mPiOFPhQH7827dvD0uWLOmaONoWxoYNG6IIli1bVuQMsnXr1iiY559/vsgRVUDt+84774TNmzcXOYMt64033jhklBguRoUxGbfffns05Oeee67IGQbDnT9/fpEaBMOnDA/e8QJ+17DyH3vssSJnGMR12223RaPm2J955plizSAcJ9uY0XvHf9ddd8Xyn3rqqSKns1TmSnnQOiAQw3OlzF2yKT3ZHpTRynaTFYwYEcycObPIGWThwoVDRs86almMqRUwwnRbanV+gzI81q5d66674YYbiqVhMHZaN44J8bAf85Tp06cXS4PQggFiSkG8CAjhdJq2hcHbobypiLGWCaSM1atXh4ceeigcO3Ysul/MSZcZPaLgt9iuzC+d7FDjYmg5GCXryqClQQD5K+4YLqJKOXz4cJzGy4EDB6KgUg4dOhQWLFhQpHzYBuz174GBgTjPxW8COnnyZJx3kraFQYuAKwW4TlbzY/TNQETbtm2LfZObb7455jF/4oknojhyUlHY9lci+OfjAUHgFuH/I4C8FdmzZ8+YhtsK/A61+X333VfkDEIrNm/evCI1Gmp/3C+OzYTAV411U4krhTis0404AKNHIGnnO8Vqifyk0RJQToqJIhWRaA2EgPtirk/eSceY77zzziI1MWh1THi4WYa5PLnrlDJnzpw4f+GFF+K8V6hEGCn0K8wtguXLl8d5OyAKBGd3Nq5kPDeqVazDnnbSIXdZxgMtBXeLEEVu3PQVcjfN4LdNpHl/xeurdJu2hMGt2rJWwdwiE0g7UMb+/fvj8lgu2mQHH95zp3A/cv9+LLi7lLs+4wGB0VJwt8ir8Wnhly5dWqSGoYWhpSjr4M+YMSPO80728ePH49z7FLVq2hKG3aI9ePBgnOfQGTTXKsdcKHOpDBNb2pFHZCY0XLQy9+xKgDsznNfcaHCJrHbG8KiNmadYp9UMj85yM/+/GYiCvgGiKLtZwjHlbhTHRAuDKMo6+HY3yu5OGWV35DpB266UdZbzmpyThRGXDQ2DodNpxz1KRUCafK8vQf8DoVXhnn1Soc+Acdx9991FzuB5QSxmoBgjIsEADYRkLo91wD3DbQWMeyxRsI3nRo0lCsDwKZvWyCoAu6uWPwPpGI3+wCgYIIFvwVul4erQWx415SxatOjjhmEXqUEawhqxT0MUxZrhdSmNWi7mUdZkIvzgvTg1XIuWpoZxjThv3jYN4xqxDWlbt3379hHpsinfj6lh8CPKzae9e/fGffiNdL9HHnnE3d4m1qfb58dPuen6qqZTp07Fc5+ib757BH3zXR/65luIFpEwhHCQMIRwkDCEcJAwakTxMepD8TF6GMXHqA8eUCo+Rg+j+Bj1ofgYPY7iY9SH4mP0KIqPUR+Kj9GjKD5GffApg+JjfAJQfIx6UXyMHkXvStWH3pUSoiVC+H+orDbfQvCWTQAAAABJRU5ErkJggg== There was an error displaying this embed.


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!