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...
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...
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...
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...
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.
...
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
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
