Smartsheets =NETDAYS Error

2JZGTE

2JZGTE ✭✭

06/06/23 in Formulas and Functions

Hi,

I'm trying to find the total days elapsed since the entry date, Column "Date". Currently I have this formula but receiving an error:

=NETDAYS(Date@row, TODAY())

Thank you!

0 ·

Answers

Peggy Parchert Community Champion

06/06/23

@2JZGTE - what is the error message you are getting?
Thanks -Peggy

0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Formula to check a box if a PARTIAL string is present in a specific cell in a descendant row.
Hey Folks! I have a working formula to check a box in a parent row if a condition is met in a descendent row. In this case, if the row "Type" is "Action Item". This is working and the formula is as follows: =IF(COUNTIFS(DESCENDANTS(Type@row ), "Action Item") > 0, 1, 0) This works well because the cell type is a drop down…
Creating a tailored drop down list in a column based on the value in another column.
Example - Risk Log. I want to be able to create dynamic filtering of a dropdown column "Sub-Category" based on the value selected in the Name/Number "Category" column. I've seen this done in Excel using the combination of: Excel Functions: INDIRECT() – to reference a named range dynamically SUBSTITUTE() – (if needed) to…
Index Match with a multi-select dropdown
I am trying to write a formula that looks at a multi-select column to pull email addresses from a reference sheet. With my current formula it only works when there is one value in the multi-select column. =JOIN(COLLECT({Reference Sheet | Contact Q2}, {Reference Sheet | BID}, HAS(@cell , [Sites to be included]@row )), "/")…