11110 - profile

May 05, 2019

I’m wondering how I can transform the formula to date format. I have the date 15/04/2019 20:46, but I got it using formulas. Now I need to add some days, thats why I’m going to use DATEADD. But there is some problem. How I know we can use DATEADD jus...

May 04, 2019

Give me advice please how I can choose just the least sumbol in the cell. Or for example 5 least symbols. Using look up I have many developments, but I want to have just the least one.

May 06, 2019

Yes, thanks! :heart_eyes:

May 05, 2019

I can’t believe, it works! Thanks :heart_eyes:

May 04, 2019

I cannot make a screenshot) I have a column with 1 and zeros. I got them with lookup. And from this cells I want to get the last number using RIGHT({Наличие в Холодильнике}, 1) formula. At the result it shows #ERROR :frowning:

May 04, 2019

Thanks! But how I know this formula works when we have a text, line. For example, I cannot make RIGHT({Name}, 3), but I can find RIGHT(“Name”, 3)

User Statistics

User Activity

Transform the formula to date format

Formula with last symbols

Re: Transform the formula to date format

Re: Formula with last symbols

Re: Formula with last symbols

Re: Formula with last symbols