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