Sign in to join the conversation:
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
How can I set up instructions from an earlier coloumn, if someone has selected Bonus A this means that a payment is due 6 months after the start date so need to show this date in the column
Hi community - ran into an issue I've never experienced before. Across all my clients, we use formulas to project dates (we've used durations/predecessors in the past, but it's not our preferred method). If we look specifically at the "TEST - SD - Internal Scope Alignment Call" line, you can see the "Start Date" formula,…
Hello. I am trying to combine contact list A with the Created By column into one Contact Helper column to use in order to restrict the user view in Dynamic View. Here is my problem. Contact List A is filled in from a form submission. The user is supposed to enter or select their email address along with the emails of any…
