I am creating an asset register with the current values of assets. I have two formula columns in use to output the current data. Wondering if I can combine/nest the two formulas into one? This is what I have now, any advice on how I would combine the...
I have tried multiple way, know I am missing something, but can't work out what. I have one column for Date and the next column is yes. Meaning that consent has been given and on the date in the column. I now need a formula field that will return the...
Ok this seems pretty simple, but I just can’t get my head around it. I am new to formulas, so get the basics, but want to move beyond.
Fields are - Member, Age, Clearance, Expiry, Valid, Current Member, Needs attention.
Basically, if the Valid field ...
Hello all, my Friday afternoon brain just can’t get my head around this. I have a large database set up for our members and need to add new functionality to it. I have duplicated the base to try and nut it out.
I need a column that is for ‘past group...
I have set up and automation to email a client when their job is marked as done, and it is working. However, I just want to make it more intuitive if possible.
Currently - When marked as done and there is an email in the ‘client email’ field there is...
Excellent! Thank you that worked! I just couldn't work out how to put it in to one calculation and it was annoying me having to hide one column rather than just doing it all in one
Thanks for your reply @Sho I did try this, but it then gives me the two answers in the same column. I am looking for the column to only show the current price. So the first line works out the amount the product has depreciated, and the next line work...
Thank you @Kenneth_Raghuna That works and gives me the valid, not valid row I was after. My work around was working too, but this is more what I am after. Thank you
I have kind of come up with a workaround that isn't exactly what I was after but works ok. I have used IF({Media Consent},DATETIME_DIFF(TODAY(), {Consent Date}, 'days'))and then created a view filtered by that column, only showing if the column total...
Thank you again! Brilliant. The first edit does exactly what I need, but will also look over the other offering. Thanks so much :slightly_smiling_face:
