-
Symbol Formula for values
I need to create Symbol Column Formula to display the following color symbols based on data in another column: Red symbol If value is in Vacation balance column is>= 175 Yellow symbol If value in Vacation balance column is< 175 AND >= 160 Green symbol if value in Vacation balance column is <160 Help?
-
Is there a formula to extract the state from an address?
Hi!! Is there a formula to extract the state from the following address? The state should be after the comma and before the zip code number. 12345 Paris Rd Dallas, Texas 75240 United States Validation Status: Validated 9856 SLEEPING BEAR RD SKOKIE, Illinois 60076-1920 COOK United States Validation Status: Validated 333 E…
-
Create a =COUNTIF Formula for dropdown column that has an IF condition
Hi Smartsheet Team! I need some assistance developing a formula that is going to count multi item dropdown columns. I am trying to create a dashboard widget that will count per Resolution Status by rep. Effectively, having a widget that shows Rep name > Resolved & In Progress (two separate counts under the same rep without…
-
Text Join Columns with a row range
Hi there- I want to Join collect the Email column(Contact field) and the Palo Alto Additional Emails column(Contact field) together with the ranges of rows 47-49 The first part of my formula worked: =JOIN(COLLECT(Email47:Email49, Email47:Email49, <>""), ", ") But when I added in the second part of the formula it didn't…
-
Need help fixing formula (single value for multiple selections)
I was working on coming up with a formula that if the user selects either one choice or multiple choices in the same category it will equal the same or highest amount. The sample data I used was as follows: Dog, cat = 3 Mouse, rat = 2 Snake, lizard = 1 The following formula was suggested to me and it does work to a certain…
-
How can I get a count of new rows created on two sheets?
=COUNTIFS({Created 2}, IFERROR(MONTH(@cell ), 0) = 5, {Created 2}, IFERROR(YEAR(@cell ), 0) = 2024)@cell
-
Match or Vlookup?
Hi all! I had a question about a formula I'm a little stuck on… For a dashboard showing our clinics information, I added a column to the sheet that feeds into the dashboard that will show which doctor is assigned to that clinic. Sheet 1 - all the clinical information Sheet 2 - dashboard metrics What formula do I add to…
-
Formulas always there
I have a sheet where people submit new items via a form. When this is done, my sheet includes three columns of set formulas. These columns are not on the form. For some reason they stopped working. What should happen: a new item is submitted, these three columns are included and automatically calculate what I need What is…
-
Auto-Assigning Project Codes Based on Status
Good afternoon, I have a formula to auto-generate a Project Code based on Approval Status and Department and department. =IF([Approval Status]@row = "Approved", LEFT(Department@row, 3) + "-" + (YEAR([Project Intake Date]@row) + "-" + IF(Prefix@row <> "", Prefix@row, "") + [Suffix Helper]@row + "")) Using the screenshot…
-
Update to Is Not Blank Formula?
How do I make this formula operate the way I need to. If there isn't a due date or a status, I don't want it to get flagged as at risk yet. =IF(OR(Status@row = "Completed", [Due Date]@row = " "), 0, IF(AND(Status@row <> "Completed", [Due Date]@row - TODAY() <= 3, [Due Date]@row - TODAY() >= 0), 1, 0))