Smartsheet cannot determine >= and <= between dates when column property is not Date

Answers

Matt D ✭✭

08/16/21

Hi @Genevieve P.
This formula worked perfectly and I cannot THANK YOU enough! Your assistance is beyond appreciated and I could not be happier with the results!
Cheers,
Matt

0 · Share on Facebook Share on Twitter
Genevieve P. Employee

08/16/21

I'm so glad you're happy with the result! Have a wonderful week. 🙂

Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
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

Creating a multi-sheet formula to match a contact list that references a drop-down list
Hello to you, Smartsheet community! I am in need of assistance with formulas. I'm so lost in the syntax that I don't know right from wrong, up from down, HAS or COLLECT 😵. I do not identify as a power user with formulas — wizards are my dearest friend — so this push into the advanced features has been a journey. Is it…
Conditional Formatting for Dates
I have two columns, one with a projected date and one with an actual date. I want the actual date to turn red whenever it is later than the projected date. How would I make this happen?
IF formula from Excel to Smartsheet
Hi, I currently have a spreadsheet in Excel I am moving to Smartsheet with an IF formula. Can someone help translate what this formula should be in Smartsheet? In Excel, the Current Widget Liabilities formula is: =IF((2023 Paid Widget Balance + 2024 Paid Widgets - Widgets Created in 2024) <0,0,(2023 Paid Widget Balance +…