Age

Ayanda108771

Ayanda108771 ✭

10/24/19 edited 12/09/19 in Smartsheet Basics

How do I create a formula to automatically calculate the age? I currently have this formula:

=(Date of Birth-Current Date)/365.25

0 ·

Comments

Andrée Starå ✭✭✭✭✭✭

10/24/19

Hi Ayanda,

This might help: https://community.smartsheet.com/discussion/calculate-age-birthdate

Did it work?

I hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
0 · Share on Facebook Share on Twitter
Ayanda108771 ✭

10/28/19

Thank you Andre.

I will have a look and try to figure it out. Idf I have further questions I will ask

0 · Share on Facebook Share on Twitter
Andrée Starå ✭✭✭✭✭✭

10/28/19

Happy to help!

Let me know how it goes!

SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

Project Intake form in one workspace updated the Intake sheet in another workspace
Hope everyone is doing well. I would appreciate any insights you may have. I used the Project Management Template (PMO) to create an new workspace. Did this by saving this folder structure as NEW and called it MS Onboarding Lite. PMO structure: MS Onboarding Lite The first time I used the PMO to create a workspace was for…
Copied Smarsheet as new, now Conditional Formatting will not work at all
I copied a Smartsheet and changed some of the column headers. I deleted all the Conditional Formatting because it no longer applied. Then when I set up new Conditional Formatting, very simple - if this cell says YES, make the row green - it will not work at all.
Rolling-up information from sheet and reports. Unable to group information.
I am creating a report that pulls data from sheets and one other report. The information rolls up fine from both the sheets and report but it does not allow me to group the information from the report. For example, I want to group by program and then sub-group by sub-project. I keep getting a "Blank" for the group and the…

Help shape the future of Smartsheet.
Share your ideas and feature requests.