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'd like to create an automation that does two things. Trigger: When rows are added or changed I want the following two items to happen. Record a date in the column "Completed". Set to today. Move row to sheet called "Completed Jobs" Please let me know if there is a way to do this using conditions?? If so, please give me…
a PM asked me to look at his schedule because one of his predecessor cells had #REF. We can't figure out why this is happening because he references line 176 in other cells in the column. When I went and looked at the schedule on my computer, the #REF error moved to a totally different cell and I don't see it in the same…
Still looking for documentation, but I am curious about the limitations with the dropdown linking in Table View. Does a person need to have access to the dropdown source sheet in order for the dropdowns to populate on the Table sheet?
