-
Populate contact cell with multiple email addresses for alerts?
I have investigated a few possibilities for this without success. Basically, I have a sheet of facilities with facility info. One of the items is what market that facility is in. So, If I want an alert to go to the entire market, I need to collect the email addresses for each facility that is in the market, then my…
-
COUNTIF or FIND Functions across multiple sheets
Hi, I'd like to try and use the FIND or COUNT function across multiple sheets. Is this possible? My idea is to have a master sheet one directory higher than all my actual data sheets and SUM/COUNT attributes based on similar criteria to the example below
-
Struggling with formula that references status in another sheet
Hello Smartsheet friends! I have a sheet (called Test Receiver Sheet) where I want a box to be checked for each row if the client code for that row matches client code on the second sheet (called TEST Client Audit Form) AND the status is "Complete". This is the formula I have so far. Im getting an invalid reference error.…
-
Looking for an easy formula to calculate anniversary off of date column
Hi everyone, Wondering if anyone has a quick and easy formula to calculate an anniversary off of a date column? Photo attached. Essentially, I'm looking for the 2022 Anniversary column to show 1/05/22 1/07/22 1/24/22 etc I understand if this might not be possible in 2022 since dates have passed, but we're making columns to…
-
Formula to replicate column values when certain value is matched
My source sheet has 3 columns such has Name, Location ID and Grade. When i provide the Location ID in the target sheet, i would require the Name and Grade values to be populated for that respective Location ID. -For ex: If Location ID 123 is entered in Target sheet only once, then all the Names and Grade which has same…
-
I would like to make a column name equal to a cell.
I would like to make a “text/number” column name equal to the a cell located in the first row of the column, can this be done with a formula?
-
RYG: Green with Conditions
Smartsheet Community: I am trying to Add a Condition to my Green Formula: =IF([Schedule Variance]@row >= 0, "Green", IF([Schedule Variance]@row <= -7, "Red", "Yellow")) I would Like it to Be Green Only if Schedule Variance is Greater Than or Equal to 0 AND % Complete (Actual) is Greater Than 0, Otherwise Blue in this…
-
count incomplete tasks due in next 30 days
I am trying to create a summary field on my project schedule that counts the number of tasks due in the next 30 days. I know a task is still open based on the % Complete (text/number field, formatted as %). I have tried the following formula based on other feeds and get an error: =COUNTIF([Finish]:[Finish],…
-
IF/AND and PARENT/DESCENDANTS
Hello, I am trying to create a checkbox column ([Parent]) that is set if the row has descendants that are flagged as being due in the coming 14 days or are overdue (this is calculated by another checkbox column [Due/At Risk]) AND if the checkbox column to mark a task as External is NOT flagged [External]. I have been…
-
Total Hours
Hello! I would really appreciate it if someone could give me any ideas on what formula I should use to calculate the total hours. Please see the sheet I am working off of. I have a form that people fill out when they get into work and clock in. I use the same form for when they clock out. I am confused as to how to do this.
