I am trying to count anything that is due this week. I have a due date column in my smartsheet, but what is the best way to count this information?
Try a formula like this where I assume your date column is called DueDate -
=COUNTIFS([DueDate]1:[DueDate]99,">="&[WeekDate]$1,[DueDate]1:[DueDate]99,"<="&[Weekdate]$2)
Populate 2 cells in the sheet in a column called Weekdate with the "start of the week" and "end of the week" dates.
Hope this helps.
I am trying to pull a phone number and email from our master roster that is on another sheet in Smartsheet. I cannot figure out the formula. This is the formula I have tried. =INDEX([EMPLOYEE NAME]@row , MATCH({IMS Master Roster Range 2}), 0)
Hi All, I keep getting this annoying error when I try to trigger a PDF generation. I initially set up to trigger the PDF generation to kick off once the last field the needs data is "not blank". That is when the error started. I modified the sheet and added a yes/no drop down to trigger the PDF generation when the value in…
Desired result is to pull the Initiative Name where the Days to Due Date is the least (so, due the soonest); then to make an index for the Top 10 Initiatives Due Soonest Currently using this formula: =INDEX(COLLECT({Project Master - Initiative}, {Project Master - Days to Due}, MIN({Project Master - Days to Due})), 1) This…
