-
Combining data in two separate columns
Can someone please help me learn how to combine data from two separate columns of a table? There are only two values in my pre-lease % summer 2024 column, and I need those two values to override/replace the values in the same row for the "pre-lease % 2024 column. I hope the attached screenshot helps.
-
Does anyone use the Entrata connector?
-
create a card to display a number ranking
can anyone point me in the right direction on how to create a card with a number ranking that will auto update? we give the sales people a score based on their activities. the one card will put them in order based off their activity score total. how do I create a separate card to just populate their Activity Score Rank?…
-
Adding Images to Table Card Using Beast Mode
Can someone help me with the formula to add a different image for each row in a table? I've been using the attached article. I've been able to get an image added, but the same image is in each row. I can't figure out how to get different images to populate in each row, like the sales rep image example in this article.
-
How do you remove some column data?
I have a column with true and false values for emails. I want to remove all the false values, but when I do, I lose the other columns (meetings and calls) in the table chart. How do I remove just the false values, but have it not apply or filter out all the other data columns?
-
How do you separate data in a column
I have a column that lists all our engagement types (call, email, meeting, text, note, and task). How do I get each engagement type to be their own column instead of all being in one? I’m trying to create a gamification points system. We want to give the salespeople 5 points for every meeting, 2 points for every call, and…
-
How do you change a date to a digit to get a sum?
I have a column that has the completion date. I'd like to change that to a number 1, so I can calculate how many have been completed. If completion date equals 6/12/2023, 6/13/2023, 6/14/2023, 6/15/2023, or 6/16/2023 then change each of those values to the number 1
-
SQL formula for blank cells
I have a table with some cells that are blank. I would like a zero to populate in the cell instead of them being blank. Is there a simple SQL formula someone could share with me to change the blank cell to a 0 number?
