Function/Formula help to input Yes/No values as well as days outstanding based on two different scen

Hello,

Can you please help me figure out formula's for the follow scenarios? I have attached a copy of my smart sheet that i'm needing to apply the formulas to.

#1) PC Action w/in 5 days (Column F): If the date in column D (Date 1st update provided by PC) is less than or equal to the date in column C(Due Date) then YES would show in column F, if the date in column D is later than it would show NO.

#2) Case resolved w/in 30 days (Column H) : If the date resolved (Column E) is 30 days or less from the date added to tracker (Column = YES; If the date in column E is greater than 30 days from the date added to the tracker = NO

#3) # of days in flight (column G) - I am using the below formula to show number of days from the time the item was added to smart sheet to the time it took to resolve. I need help figuring out what i need to add to the formula for this show # of days from date added to tracker to today if Date Resolved field (Column E) is blank.

=NETWORKDAYS([Date added to tracker]460, [Date Resolved]460)

Any guidance you could provide would be greatly appreciated!

Thanks so much!

Tiffany

Find more posts tagged with

Formulas

Comments

Sean Morgan

Hello Tifair,

Thank you for reaching out within the Community.

I have performed some testing and have created a formula for each example. Please note that these are examples and will require modification to work within your sheet.

1) =IF([Date 1st]@row<= [Due Date]@row, "Yes", "No")

2) =IF([Date Resolved]@row - [Date added to Tracker]@row <= 30, "Yes", "No")

3) =IF(ISBLANK([Date Resolved]@row), NETDAYS(TODAY(), [Date added to Tracker]@row), NETDAYS([Date added to Tracker]@row, [Date Resolved]@row) - 1)

Here are the articles on the functions I used to create each of the Formulas:

Formula Basics: https://help.smartsheet.com/learning-track/get-started/formula-basics

IF: https://help.smartsheet.com/function/if

ISBLANK: https://help.smartsheet.com/function/isblank

TODAY: https://help.smartsheet.com/function/today

NETDAYS: https://help.smartsheet.com/function/netdays

If you face any issues or have any further questions, please reach out

Kindest Regards

Sean

Sign in to join the conversation!

Quick Links

Trending discussions

A multiple SUMIF function
My current formula is below. I would like to update this so that I only get a total of those that have been Quoted and have a timeframe data of 2025. How do I add this extra filter into the formula? =SUMIF(Status:Status, "Quoted", [Est. GP]:[Est. GP])
Missing column in Report if I use a formula
I'm not able to "view by" a field that I have in my sheets - Quarters (Q1, Q2, Q3, Q4) - in my report. I think it is because I have used a formula to calculate the quarters in my sheets. Does anyone know a way to get a formula based field on the dropdown for view by in my report?
SUMIF function not working
=SUMIFS({GM Compliance Trained}, {GM Compliance Training Dept}, Department@row , {Compliance Training Date}, MONTH(7, 8, 9)) GM Compliance Trained is the number of employees trained. I am trying to sum the number of employees trained in each department during 3rd quarter (July 1-Sep 30). Thinking I need an IFERROR in there…