Hi,
I am trying to subtract two dates and have it return as the number of years. I have not been able to find any "date" formulas that will work. Any ideas? See screenshot
=CONVERT(cell reference to length of tenancy column,"day", "yr")
In this case if you subtract
= move-out - move-in and then apply the formula for convert it should work
Instead of the covert function (that works in excel -- not in smartsheet)
= ([move-out] - [move-in])/365
I have an automation set up so that when the Status column changes to Complete, Canceled, or Not Needed, Smartsheet automatically updates the % Complete column to 100% (Text/Number column type). After that, another workflow should trigger to alert the next person that their task is ready. This worked fine before, but…
I'm working on a formula that will return a count based on a matching dates and the word "Quality", but I'm getting the unparseable error. I'm sure it has to do with where I'm putting the ) and ,0 ,1. Here are some that I have tried:
I need help creating a formula that references the "Due in Payroll" column I have which is a series of dates. I would like the formula to look at that date column, and return whichever date in that column is closest to today's date. I've tried several formulas, all come up invalid column type, unparseable invalid…
