-
Formula for Lights
Hi all, I have a sheet that contains fields for "Preparer Due Date" and "Preparer Status" and am trying to add in the following logic to a formula: If Preparer Status is "Complete" OR Preparer Due Date is earlier than today AND Preparer Status is NOT "Complete", then put a green circle If Preparer Status has a status ofβ¦
-
JOIN(COLLECT 2 CONTAINS criteria with multiple returns Cross Sheet
Hello! I'm looking to build a JOIN(COLLECT that will allow me to pull email addresses from a contact sheet based on two criteria. Both criteria have to be CONTAINS. They will be the Department (Dept) and the Job Title (Role). I frequently send out emails based on department, but also specifically to the managers of thoseβ¦
-
creating formulas for column and rows linking to other sheets
I could not find what I was looking for in other questions so I will try to pose what I need help with here. I have one sheet that I have columns and rows summing totals from another sheet ... so totals by the week and the location. I now want to create a 7 day average on an existing sheet that I was doing a 5 day average.β¦
-
COUNTIFS - trying to make a formula that does the same work as the "Has Any of" filter from Reports
Im very new to writing Smartsheet formulas and have been scouring these forums the last few days to try and figure out how to get this to work I am trying to write a formula that counts the rows with the following column criteria. Here is what I have so far but its not working =COUNTIFS({Module}, OR(@cell = "AMBFO", @cellβ¦
-
Checkmark Column Formula
Afternoon, I have tried every formula in the book to count all check marked boxes within a column. Can anyone just write the formula that works for them? This is the formula I am trying to make work- =COUNTIFS([Construction Complete- Not Submitted]2:[Construction Complete- Not Submitted]254, 1)
-
I am trying to modify an existing formula using (AVG(COLLECT and want to add a new value
Current formula is as follows: =IFERROR(AVG(COLLECT({BR - Campaign Roadmap Update Ref Duration}, {BR - Campaign Roadmap Update Campaign Status}, "In Development", {BR - Campaign Roadmap Update Vehicle}, [Vehicle Type]@row)), "0") Now I would like to add an additional value to the AVG COLLECT function. In addition to "Inβ¦
-
Can I use IF statements for symbols based on a dropdown column?
Hello, I've been trying all of the solutions from threads about symbols changing using IF statements, but none seem to be working. I have a column called "Status" that is a dropdown and includes different application statuses like "Applied" and "Admitted". I want a different column called "Status bubble" to update theβ¦
-
Formula
I am trying to add a metric on a sheet summary for campaign tracking that pulls from two options on a column dropdown. Option A is campaigns that are βIn Developmentβ and the other is βIn-Marketβ. I want to get the average in another column that is βdurationβ of days for campaigns that are βIn Developmentβ and not βInβ¦
-
IF is Integer?
I have a formula column that is constantly changing and bringing in live information. If the numbers are integers, I want to see them rounded with no decimal point. If the numbers do have decimals, I want to see only 1 decimal place. Pressing the increase/decrease decimal button doesn't help, since I need it to depend onβ¦
-
Using a Risk flag
I want the flag if the date is past due, but it's also giving me a flag if the end date is blank. what am I missing here? I tried to add another NOT statement and ISBLANK, but then was just getting errors. =IF(AND([End Date]4 < TODAY(), NOT(Status4 = "Complete")), 1, 0)