Hello Community! I need some guidance... I have a few columns with fields that are Single Select and one of the options is "COMPLETED". I am looking for a way to create a formula for it to add "how many COMPLETED fields" I have for that record... For...
I'm thinking I can use a 'formula' field to do this task. Can anyone help with the 'Formula' field... or is there a better suggestion. Thx.IFFirst 4 characters of a record in {Unit & Week} = First 4 characters of a record in {Unit Name} AND {2023 Fee...
I have a campaign work back schedule. I need to calculate four date fields based on the Launch Date:Assign Due DateDeveloper Due DateQA Due DateApproval Due DateLaunch DateThe number of days for each due date varies based on the combination of two si...
Hello communityAgain faced with this, hope to get a simple workaround for this where I can get a formula that extracts URL from a text field. Thanks
I'm new with these and I think i'm having a big mistake but I cannot find it.I'm trying to extract the number of hours for an specific duration record.Obviously I use HOUR command but it doesn't work!As you can see in screenshots, the field Hours wor...
the circled part is the focus… let take for instanceIf the "display attachment field" is not empty and the "cloud hosted field" is empty, a formula to display the display attachment field and not the cloud link fieldIf the "display attachment field" ...
Hello,We are running a time study with our teams and we are bringing our data into Airtable from a time tracking tool.We are running into a scenario where a designer could have multiple time stamp entries for the same task on a project. The problem i...
I have a survey set up with 5 of outcomes depending on the total amounts of points. To assign a certain score to a certain outcome I used the IF statement. See attached files. It does not work properly for at 60 points it should show 'Extreme angst'....
Hi All,I need some help with extracting specific text. I've looked through the community and tried to apply the examples offered...but I am not getting it quite right.I need to extract the suburb, state and post code from a (text) address field. Some...
Hi all, I am looking to create an interactive leaderboard, where my students fill out a form which relays the results back into a board. I have a rough idea of how to do this, but was wondering if anyone has attempted this before or any leaderboard t...
I have to regularly place Facebook/Google pixels on webpages and was wondering if there's a way to track via a formula, button, or script whether the pixel on that webpage is working or not. I have a field in the table for the URL the pixel would be ...
