Invalid Value ERROR

System

System Employee

09/20/23 in Formulas and Functions

This discussion was created from comments split from: Newbie: trying to return cell contents if date is less than and greater than....

0 ·

Answers

WinaHath ✭✭✭✭

09/20/23

please also help me; this formula is returning an "invalid value. The column is a Date
=IF([Date of Last Invoice]@row < DATE(YEAR(TODAY()) - 2, MONTH(TODAY()) + 6, DAY(TODAY())), "Inactive", "Active")

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

Schedule health formula to display blank symbol
Hello! I am curious how to edit the below formula, to show blank instead of green/yellow/red symbol if status/end date is blank: =IFERROR(IF(Status@row = "Complete", "Green", IF(Status@row = "N/A", "Green", IF([End Date]@row = TODAY(), "Yellow", IF([End Date]@row < TODAY(), "Red", "Green")))), " ")
Count HAS Function Between Dates
I have worked to find a solution out there but not getting one that works. I am collecting data from a sheet to be used in charts on a dashboard (so referencing another sheet). The result will need to be generated from two columns Date - date the project closed Fund - The fund/funds used to pay for the project (multiselect…
Multiple IF Statements Using "ISDATE"
I have an existing formula that enters text based on two criteria: if a date exists in a column, and if that item was closed prior to the anticipated delivery date. The current formula is: =IF(ISDATE([Closed Date]1), IF([Delivery Date]1 > [Closed Date]1, "Complete", "Fail")) I'd like to add an additional criterion that…