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
Hi all- I need help trying to extract the month number from another column. My 'Notification Date' column uses a formula (based on the service 'Type') to calculate a specific timeframe. I need to extract only the month from this 'Notification Date' and populate it in the 'Annual Review Month #' column. I was good until I…
Looking to find out the correct formula for the below scenarios Sheet One contains: - Price and Contract ID Sheet Two contains: Contract ID Formula should be added into a column on Sheet 2, summing the Price of all rows from Sheet One where the contract IDs match
Hello Smartsheet Community, I'm trying to extract email address from contacts column in my smartsheet, but I am unable to do that. i tried using basic string functions funcitons such as find, trim etc to extract the email part between < > but I am encountering errors. can someone help me with a working formula to extract…
