NETDAYS based on IF statement

I'm trying to use a NETDAYS function to determine how many days overdue a payment is, but I only want to display that number of days if a column named 'Status' has the value 'Client payment pending'.

The function I'm trying to use is =NETDAYS([Date Sent to AP/CR]398, TODAY()) but I don't know how to work that into a conditional statement. I want this to output the netdays only if the Status column has the value "Client payment pending'.

Can anyone provide some help? Thanks in advance!

Find more posts tagged with

Formulas

Legal

Project Management

Comments

Mike Wilday

Try this,

Edited: to include quotation mark after Pending!

=IF(Status@row = "Client Payment Pending", NETDAYS([Date Sent to AP/CR]@row, TODAY()) ,"")

This will only run the netdays if you have a Client Payment pending status in the status column. Make sure that your status column is title status. If not, change the status@row to indicate the actual column [Your Column Name]@row

@row will look at the current row and doesn't require direct reference to the row numbers!

https://help.smartsheet.com/articles/2476491-create-efficient-formulas-with-at-cell

SD@HL

Thanks so much for the help! That solved my issue (and helped me with a few other things I had questions about as well!)

Just an FYI for anyone using this in the future, there should also be a quotation mark (") after the word 'Pending' in order to avoid an error

Mike Wilday

Awesome! Glad I could help. I edited the formula above to include the quotation mark after Pending! I'm glad you caught that!

SD@HL

If I wanted to run this same function but have it triggered by multiple different values in the Status column ("Client payment pending" OR "Sent to AP/CR"), how should I modify the formula?

Sign in to join the conversation!

Quick Links

Trending discussions

Auto Fill Date When Column Checked
I want my date column to auto fill when I check the column Verification and Closure. What formula do I use? I want to ensure that the date doesn't change as time goes on.
Employee Reviews - Pulling & Averaging Category Scores
Hi all, thanks in advance for your assistance! I am working on building a new employee review process for my company and am caught up on one of the final steps. Here's where I am at: I have created an employee review form that individual managers will complete Each employee will have 3-5 reviewers The form submissions will…
Need Formula for Subtracting Order Quantities from Inventory Quantities
Hi! What formula would I use in Smartsheet to automatically subtract a quantity from one sheet based on what is submitted in another sheet? I have one sheet that is where we will manage the "orders submitted" and on that sheet is different columns for different items that can be ordered and the quantities requested for…