Add Myriad Formula with airSlate SignNow

Add myriad formula

we can take our custom feels a little bit further if we like by adding in a formula to them so actually getting the custom field to be calculation based on of the data for this particular example we're still going to used in my bedroom 2014 as our base working file but I'm going to change the view to the resource sheet and then create a couple of fields in here to show that we're not just restricting ourselves to the tasks now if we want to create a resource custom field we go to the resort cheap tools format and we'll see there's a custom fields option here it takes us to exactly the same dialog box as we've been previously but it's already moved the dot into resource only because of the route we came in we could still use this same box to create a task field if we sell light I want to create a resource field this time we're also going to change the data type to a cost data type so that's a monetary field and then our first field we're going to use here cost one let's rename that to be Inc tax going to create a field that includes the tax this time in our attributes we're going to move the doctor to formula it then warns me that any current data already in that field will be discarded and be replaced with the formula but we don't yet have any data in that field so that's fine okay we can then click the formula dialog to bring the formula dialog box and here we simply type our formula it already starts off as Inc tax equals so all I need to put in here is the formula that works out the tax well the tax is a numerical value multiplied by the cost so the first thing I need to find is a field it's a cost field and the cost field then places the cost field into my white box I can use the normal operators for multiplication which is the asterisks or I can choose it from my little list here we're going to multiply the cost by 1.3 so that takes the cost built into the project for a work resource and multiplies it by 1.3 so adding on 30% to work out the value including the tax now you'll find in this dialog box all the operators are listed along here so we've got plus minus multiply divide and Poisson for concatenation mod for the remainder slash little hat for syntax further power of open closed brackets equal not equal to less than more than and or not so most of the operators you would want plus access to all the fields currently in your project plus access to a myriad of functions are available broken down to categories for conversion date/time general math backs of project functions and then text functions there's everything you would need in here whatever you leave in the white dialog box is what it will try to calculate so my formula is going to work out that the ink tax is equal to the cost multiplied by one point three okay it then gives me pretty much the same warning again about everything already in that field being deleted and replaced with this calculated value that's fine I know that okay then have the option for roll-up in task and groups well this is the formula to be used really just in the resource sheet so I don't need to roll it up and I don't need to roll it down for assignment rows and I want to actually see the data not a graphical indicator so everything is working as I would hope for the ink tax okay all I need to do now is see it so let's add it to our resource sheet insert column I'll type in the name of the field which is Inc tax and then this column appears that works out the cost multiplied by 1.3 to get me the inclusive cost with tax if I also insert the actual cost field I can then tell if the calculation is working out 20 becomes 150 6-3 7-5 becomes 4x 750 that's working out spot-on six to seven 80 that's a little easier to work out in your head so formula custom fields are really available and only restricted by your requirements let's add one more just to demonstrate that we can do a slightly different formula field this one's actually going to be a text form and field let's rename and it's going to work out the upper case release it's going to alter the string content of the resource name so I'm going to call it upper case name okay it's going to be a formula field so I'll get that same box that says you're going to put a formula in everything in there will be deleted we know that thank you and then the formula itself is going to be uppercase name equals now there are text functions within here and we can find the uppercase one there it's you case that places UK's Open bracket string close brackets I need to replace the word string with the actual resource name that's under field texts and name okay and I'm presented with that same warning that's fine we know because this is a straightforward text manipulation string okay and then we simply insert that new column drill name we find we have the names in uppercase and because I've created that new field I can use that field in other places such as on the Gantt chart when you want to customize the label that appears next do the task so there are plenty of other text manipulation functions within there should you wish to do chopping of strings at the moment we've simply looked at the mechanics of creating that custom field in this case we've looked at the mechanics of creating custom field that include formulas be they mathematical or string based