Robert_Hudman - profile

Robert_Hudman · Jul 27, 2018

Hi There I am trying to set up a formula to read from a single date field and provide an output text to give me three desired output. As below: If the date <= today’s date + 30 days - show as “30 days”If the date <= today’s date + 60 days (but not eq...

Robert_Hudman · Jul 26, 2018

Hi All I am in early stages of learning formula functions, and focusing on date based formulas. One thing I have noticed is that dates created from formula calculations to not seem to work with the Timeline block. Has anyone found a way to make this ...

Robert_Hudman · Jul 31, 2018

Hi Guys Just found out that you (should be able to) convert the date string from using the DATETIME_FORMAT formula into a proper date format that the Timeblock can read by wrapping it in a DATETIME_PARSE formula. Have not tested it out, but thought i...

Robert_Hudman · Jul 29, 2018

Thanks Luiggi Works perfect You have taught me a great deal!

Robert_Hudman · Jul 27, 2018

Alright…just figured out there is a DATEADD function! :grinning: Using this it seems to work: IF({Conservative Date} <= DATEADD(TODAY(), 30, ‘days’),“30 days”,“nested”) Can anyone give me advise on how to deal with the 60 days and 90 days in the ...

Robert_Hudman · Jul 27, 2018

Hi Elias I don’t know if I have somehow not followed your instructions(?), but can assure you I worked through them in detail before coming back to ask follow up questions. Your advice is great appreciated. Robert

Robert_Hudman · Jul 27, 2018

Hey Luiggi Well that makes a lot more sense…thank you! Any help you can offer would be awesome.

User Statistics

User Activity

Nested IF Formula Help

Date formula with Timeline Block?

Re: Date formula with Timeline Block?

Re: Nested IF Formula Help

Re: Nested IF Formula Help

Re: Date formula with Timeline Block?

Re: Date formula with Timeline Block?