I need to reefer to another sheet and count any row that has a "Fill Superintendent" and return a number if it is =< today in column. Then a valve if its => 60 days
Thank you for any help
Hi Creve,
Here's a couple of formula examples that would meet your business rules:
To count the number of tasks where the Assigned To is "Fill Superintendent" and the start (or end) date is:
Less than or equal to today:
=COUNTIFS({Assigned To}, "Fill Superintendent", {Start Date}, <=TODAY())
Greater than or equal to 60 days from today AND less than 90 days from today:
=COUNTIFS({Assigned To}, "Fill Superintendent", {Start Date}, >=TODAY(60), {Start Date}, <TODAY(90))
Greater than or equal to 90 days from today AND less than 120 days from today:
=COUNTIFS({Assigned To}, "Fill Superintendent", {Start Date}, >=TODAY(90), {Start Date}, <TODAY(120))
Anything greater than 120 days from today:
=COUNTIFS({Assigned To}, "Fill Superintendent", {Start Date}, >=TODAY(120))
If needed, more information on cross-sheet formulas can be found in our help article: https://help.smartsheet.com/articles/2476606-formulas-reference-data-from-other-sheets
More information on the TODAY function can be found here: https://help.smartsheet.com/function/today
Hey, Is anyone else facing this issue in the approval notifications sent through smartsheet
I have a sheet with a list of customers in one column, and then the following columns are City, Monday, Tuesday, Wednesday, Thursday, Friday. I need help with a formula that I can put in my sheet summary so that if the customer column says Staples (It can say this in multiple rows) that it will tell me the total package…
Hi Smartsheet community, I've always tried to answer questions but this is my first time posting. So I have formula =IF([Project Status]@row = "Complete", 1, 0) set up in the "Complete Check - Hide column" to check the box when the project status is marked complete. The project status column is tied to several other sheets…