If my event is September 2, 2025 (aka "program start date"), it would be in Quarter 3, 2025. But I need to list that commission would be paid the following quarter (aka "quarter earned", so Q4, 2025. Fiscal year runs Jan - Dec like the calendar.I cur...
Hi again,Is there a way for you to have data from a field "written" to that field and fixed for those changes elsewhere will not affect the result in this field in the future?An example of this might be;A fee in one table is designed to be updated in...
Hello everyone!I need help with a formula that computes two fields as {field 1}/{field 2}.However, the base is new for my team, and we're working to input backdated data, so some records that use these fields are 0 (zero), at the moment. The formula ...
Trying to figure out how to do a search to see if a number falls within 2 fields.For example a field with Start year and a field with End year. Lets say on one record my start year was 1978 and my end year was 1986. I would like to do a search for ...
I have a few currency fields that I am adding up in a simple formula field. I am then trying to display the output of that formula field within a text string I am building with another formula. However, I’m getting some strange decimals when showing ...
I need to calculate different due dates for tasks based on Workday instead of dateadd. Here is my original formula: SWITCH( Task, 'Email for photo, new hire survey, and short bio of new hire', DATEADD({Hire Date}, -7, 'days'), 'Assign desk space f...
Hi,I have a base where I keep my business's time entries for each of the employees. However, they may be in a different state based on the day, so I'm looking for a way to populate a field for each time entry showing their location.The time entries ...
Hello!I was recently helped on another post to create parameters for the dateadd function. However, it is not calculating dates correctly. Why? How do I fix this?Here is my function:SWITCH( Task, 'Email for photo, new hire survey, and short bio of ...
Hello!I am wanting to add a DATEADD formula to my base to set deadlines for different tasks based on a hiring date. I've done this in a previous base, but have since lost access. Can someone help me with the formula I need? For reference, some of the...
Hi,I want to create a formula to create a name for a field that consists of "FIELDA" or "FIELDB" If "FIELDA" has no value i would like to show "FIELDB" in the name instead. If "FIELDA" and "FIELDB" both have a value, I would only like to have "FIELDA...
| User | Count |
|---|---|
| 904 | |
| 836 | |
| 611 | |
| 551 | |
| 378 |
