This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hello! I am trying to create a formula to help track tenure and extension dates for personnel.
Each person has a “start date” – I want to have formula fields that calculate quarterly extensions +12 months; +15 months; +18 months
Here is the formula I...
Hello!
I have 2 tables on my base:
1 - assignments
2 - resources
The assignments table (1) allows users to inout a project and then select from a linked record of “name” in table 2 to assign a resource. They then input the % workload this project wil...
Vivid-Squid:
IF({Date Start} != "", DATEADD({Date Start}, 12, 'months'), "")
I got this error when I tried formatting, do I need to add a DATETIME_FORMAT element to the formula?
Thank you, that worked! However, the formula is showing time which I do not need:
Also, I know there is an IF function I can add to the formula so I don’t return an #ERROR if there is no date in the “start date” field.
Lauren_Madfis:
DATEADD({Start Date},+12,‘months’)
@Vivid-Squid I tried that and still got an error! I tired adding spaces, removing them, etc but keep getting an error.
@Rupert_Hoffschmidt
Yes, this is what I need! Thank you!
Can you explain how to do this step by step?
In my “resources table” I’ve created a linked column for “assignments” – how do I get that to automatically populate with all assignments the resour...
