ta2530 - profile

ta2530 · Oct 22, 2024

Hello everyone,I am trying to get my formula to recognize numbers >= $0.00 in all of the columns listed: My formula: IF({August FY25 Projections},{August FY25 Projections},IF({FY Start Split Formula},{FY Start Split Formula},{Original FY25 Revenue P...

ta2530 · May 16, 2024

Hi all - I need help with this formula as I was able to use Chat GPT to get me close to where I need to be, but it still doesn't work.Can someone rewrite this formula so it works: IF({End Date} > "7/1/2024" , {Latest Revenue Projections} * ("6/30/202...

ta2530 · Jan 31, 2024

Hi there - I am looking to create a column that will essentially lookup the field values of columns Q1 - Q4 and output the latest number.We input quarterly projections and want to be able to identify the most recent number by looking at 1 field ("lat...

ta2530 · Jan 05, 2024

Hi there - I am having trouble creating automations to change the status of a single select field based on start and end dates.Example 1 - I need the status to change from "Scheduled" to "Live" once a start date has passed. As in, if a class has a st...

ta2530 · Oct 22, 2024

This worked. Thank you so much!

ta2530 · Feb 01, 2024

Thank you!This worked well I just needed to add an additional ) at the end.

ta2530 · Jan 10, 2024

Thank you for your response! I love the simplicity of the forumla as I am very unfamiliar with Scripts. My only issue is that I wouldn't be able to manually change the status in a formulated field and I would need to do that as well.Example - if I ha...

User Statistics

User Activity

Nested IF Statement not recognizing $0.00

Need help with complicated date based formula

Formula to display most recent input based on multiple field

Automate record status based on dates

Re: Nested IF Statement not recognizing $0.00

Re: Formula to display most recent input based on multiple field

Re: Automate record status based on dates