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...
I'm stuck. I need a field type and formula to display the cumulative annual profit or loss (P/L) displayed as a percentage (%) and based on a Q1 starting amount and subsequent amounts entered in Q2, Q3, & Q4 fields.This seemed easy until I got starte...
I want to filter to the infinity values but am unsure how to do this. I don't want to remove them using an IF statement or the other tricks you can use to have them become zero or empty values. The first screenshot shows the data and that there is on...
I have a [Anniversary] field and a field that calculates the next anniversary, so I get reminders and write a card for my volunteers. Here is my problem:The basic formula works fine when there is an anniversary in the field. When there isn't one, I g...
I am trying to sort by the Week # of the year that an entry is assigned on my base. Its sorted by year, then by week - so 2024, week 1 through 52, etc.However, for anything this week up until the 31st, its showing up as the 1st week of Dec 2024 (whic...
Hi,I've created a formula to calculate my patients' current age based on their date of birth (Lookup field). When I look at the record in grid view, it gives me an error message, but when I check the formula for accuracy, the calculation preview give...
| User | Count |
|---|---|
| 904 | |
| 836 | |
| 611 | |
| 551 | |
| 378 |
