Best Of
Re: Date Dif Formula
Smartsheet does not have a DATEDIF function at all. We have to write our own formula to mimic. Something along these lines should work:
=(YEAR([End Date]@row) - YEAR([Start Date]@row) - IF(MONTH([End Date]@row) < MONTH([Start Date]@row), 1, 0)) + " years, " + (MONTH([ENd Date]@row) - MONTH([Start Date]@row) + IF(MONTH([End Date]@row) < MONTH([Start Date]@row), 12, 0)) + " months"
Paul Newcome
Re: Has anyone made a short cut sticker for computers for smartsheet?
hi @EEK,
that's great idea to have everything on a sticker! I have just a A4 card with all the smartsheet shortcuts.
kowal
Re: Pulling Parent Task Name and Child name to New Column
Glad to hear it worked!
Happy to help.
Best of luck to you in your solutioning!
Ray Lindstrom
Re: Join 2 Columns that are not next to Each other.
Hello @SherryFox!!
Oh start me off with an easy one for the day! I love it!!
= #@row + " - " + [Task Title]@row
Re: Happy 10th Anniversary Community + Giveaway!
Smartsheet is like if Excel went to therapy, got super organized, and decided to manage projects instead of just ruining your day with broken formulas.
mcullen
Re: Creating a PO # using todays date
You would insert a Date Created type column and then use
="PO" + RIGHT("0" + MONTH([Created Date]@row), 2) + "" + YEAR([Created Date]@row)
Paul Newcome
Re: Happy 10th Anniversary Community + Giveaway!
Smartsheets make all reports, tasks, schedules, harmonize efficiently, ensuring timely success.
SCSDmoore
Re: Happy 10th Anniversary Community + Giveaway!
Smartsheet puts product development into an organization's hands allowing them to customize their own needs in a variety of ways.
StevenBlackburn
Re: Happy 10th Anniversary Community + Giveaway!
Smartsheet lets anyone create solutions that help you understand what's happening at your organization instantly!
Adam Costello