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
Hi, I am a user for a paid plan, but for some reason, smart sheets stopped letting me edit. How do i fix this so that i can edit a dashboard? Thanks!
Hi Everyone, We currently have a Smartsheet business plan and we wanted to know if it was possible to invite people into workspaces, but limiting what they see in the workspace. A few users would like to be able to edit some sheets within this workspace, but it is not allowed since their accounts are set as viewers. Is…
Hi everyone, in several of my Details Views for multiple Dynamic Views, text fields and/or checkboxes that are configured in the Dynamic View settings are not appearing in the Detailed View. Is anyone else seeing this today? I've not updated any of my configurations lately and don't know how to explain this! Thanks!
