Sign in to join the conversation:
How do I create a formula to automatically calculate the age? I currently have this formula:
=(Date of Birth-Current Date)/365.25
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
Thank you Andre.
I will have a look and try to figure it out. Idf I have further questions I will ask
Happy to help!
Let me know how it goes!
I set up an automation - with very specific details. I included just a few of the smartsheet fields which were needed. One of the fields includes a checkbox with items that were checked off to be included in the automated email. Although it seems that we set it up properly, it is not working and that column shows up, but…
I use Smartsheet for our audit process. It has worked wonderfully all year but a new set of audits just came in and for whatever reason my team has lost the ability to check the completed check box in the sheet. I have checked to make sure the column is not locked, upgraded their permissions to admin. No luck. Screenshot…
We have multiple projects for 150+ countries and we want to create a heatmap style grid to track which project is live in which country. Ideally, we want to convert this grid into a timeline, what would be the ideal way to create this smartsheet?
