Wendy_Yelsik - profile

Wendy_Yelsik · Jun 28, 2024

I want to store the total number of employees in the programs table to calculate the participation rate. Additionally, I'd like to break down the number of employees by position to calculate the participation rate for each position. I have three tabl...

Wendy_Yelsik · Oct 26, 2023

I am trying to auto-number a group of records for one person in a table with multiple people listed with numbers 1,2,3, etc.. In Excel, I would use a formula to add one number to the above cell, and it would number all rows sequentially. I usually ma...

Wendy_Yelsik · Oct 19, 2023

My field has a name followed by a number - SAM ADAMS (1234). I need to put the 1234 in it's own field. What is the best way to write a formula to do that?

Wendy_Yelsik · Aug 03, 2023

What formula would I use to combine these two fields and get this result?Desired result - "3.69% | Increase"I tried this formula and the result is in % STATUS off…CONCATENATE({01% DIFF OFFICE}&' |'&{CHANGE TYPE})

Wendy_Yelsik · Jul 13, 2023

If you share a read-only Interface, is the person with read-only access required to create an Airtable account? I wish to share an interface, but I don't want the read-only user to create an Airtable account and login each time they have to view the ...

Wendy_Yelsik · Jun 28, 2024

@Russell_Bishop1 - It's working! Your suggestions really helped me get everything configured correctly. Thank you! - Wendy

Wendy_Yelsik · Jun 28, 2024

Yeah. However, the DDONE consists of employees who have completed the programs. I have to get the number of employees, regardless of whether they completed the program, into that same table. I have to think it through.

Wendy_Yelsik · Jun 28, 2024

I don't create a task for each employee who should attend. The only task is created when the employee submits a Fillout form integrated in Airtable, which creates a new record in the task table. I also tried using the second option, but it seemed to ...

Wendy_Yelsik · Jun 28, 2024

oh- I do not allow for multiple records in the tasks table. Each employee can only have one record per program.

Wendy_Yelsik · Jun 28, 2024

@Russell_Bishop1 - thank you for the information. I already have that information in a table called "Tasks." However, I may not have the linked tables set up correctly. I've been using this base for years and have tons of data. Here's a snapshot of w...

User Statistics

User Activity

Calculating Participation Rates

Numbered Bullet List

Extract numbers from field into a new field

Combining % formula field with Text field

Read Only Interface

Re: Calculating Participation Rates

Re: Calculating Participation Rates

Re: Calculating Participation Rates

Re: Calculating Participation Rates

Re: Calculating Participation Rates