Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
=IF(ISDATE(DOB1), IF(MONTH(DOB1) > MONTH(TODAY()), YEAR(TODAY()) - 1 - YEAR(DOB1), IF(MONTH(DOB1) = MONTH(TODAY()), IF(DAY(DOB1) > DAY(TODAY()), YEAR(TODAY()) - 1 - YEAR(DOB1), YEAR(TODAY()) - YEAR(DOB1)), YEAR(TODAY()) - YEAR(DOB1))), "")
Is this a helpful formula, or are you looking for assistance?
If it's the former, thank you as I can see a formula like this being very handy. If it's the latter, then that is properly lazy.
Either way, putting some more detail around what the formula represents would be great.
Kind regards,
Chris McKay
Hello community, What can we do if I cannot delete the data shuttle workflows that I created myself? Thanks!
Hello, I have created a dashboard and added some Metric Widgets to my dashboard that is pulling text from the profile data sheet that I created. However, on the screen shot below, where it is pulling information into, I want to change the formatting (no bold, smaller font). But when building the dashboard, it doesn't let…
Hey, in the smartsheet we have been working on, user can create work orders and that will get displayed in the application. so one action performed recently was using the option 'Copy to Another sheet' for a set of multiple rows and deleting them later in the source sheet , due to this it caused 404 errors for all the rows…
