Sam_Giovenco1 - profile

Sam_Giovenco1 · Dec 03, 2023

Hi There,Seeking some help writing a formula to show the minimum of two date fields in a specified format. I have it working but showing without a forward slash.Formula used so far is =MIN(VALUE(DATETIME_FORMAT({6QIssuedDate},"DD/MM/YYYY")),VALUE(DAT...

Sam_Giovenco1 · Jun 17, 2022

Hi There, Seeking some assistance on how to use the rollup function. I have two tables, one where all the actual data exist ie number of opportunities, one line per opportunity. Can be multiple in a single day. We have a status column to indicate wha...

Sam_Giovenco1 · May 16, 2022

Seeking help with a “If” formula to create buckets in a new column. For example, in column A i have series of different percentages. IN column B i wish to create a formula and returns a “text” if it meets the criteria…for example, if A1 = <100, “<100...

Sam_Giovenco1 · Feb 24, 2022

Base record that contains customer email who i wish to send to inform or request to collect information using series of templates. Could be follow up of a lead or requesting further information to processing their enquiry. Something like adding an em...

Sam_Giovenco1 · Dec 03, 2023

Thanks @dilipborad that worked perfectly 

Sam_Giovenco1 · Jun 20, 2022

Hi Adam, See attached screen, i need it it to calculate a running MTD figure…once i have that i can then create a formula to work out the variance as we travel through the month. Column D is what i need to solve which is a running tally of column C. ...

Sam_Giovenco1 · Jun 19, 2022

Adam, that is legendary…ive managed to make it work in my data. Now a fresh problem is i need a running tally of the results to compare Forecast MTD to Actual MTD… this is currently how i have the data setup

Sam_Giovenco1 · Jun 18, 2022

Thanks Adam, Ive kind of got it to work but requires me to select the records to rollup which i want it to do itself as there are too many. The below screen is the raw application data sample

Sam_Giovenco1 · May 21, 2022

Got it, thats worked…thanks

User Statistics

User Activity

Formula to show min date in DD/MM/YYYY format

Help with rollup formula

How to create buckets with a formula

How to send an email/sms from a record using a template

Re: Formula to show min date in DD/MM/YYYY format

Re: Help with rollup formula

Re: Help with rollup formula

Re: Help with rollup formula

Re: How to create buckets with a formula