-
Lookup contact name from email address
Hi, Users enter data into a sheet via a Form. One of the columns is a "Created By" system column. This provides me with the email address. Is there a function to lookup the name from the contact list based on the email address. I'm aware that I could achieve something similar by have a second sheet with Names and email…
-
Trying to Average Days based on a Text Field Criteria
I am trying to get the average days that a contract took to execute after a specific date, however only for items with the text status of Support, what is the best way to do this in smartsheet? =AVERAGEIF([Status]:[Status], "Support", [Contract Signed]:[Contract Signed], >DATE(2020, 7, 1), [Contract to GL Days]:[Contract…
-
Need help with a function
I have a sheet that has 2 columns Required for (Sprint 1, Sprint 2,.....) Build % Complete (values - 0%, 50%, 100%) I need to know how many Sprint 2 items have 0% Build % Complete. My function is COUNTIFS(<Required for:Required for>,"Sprint 2",<Build % Complete:Build % Complete>,"0%") This function is always returning 0…
-
Automated Workflow Monthly Archiving
Hi everyone, I am attempting to set up a specific automated workflow to perform archiving. Normally this wouldn't be an issue however I'm using this function to try and have a chart on the dashboard to display the current months data and 11 months prior - so it is a "rolling" chart so to speak. The nature of my current…
-
Is It Possible To Clear Entire Sheet Without Clearing Formulas
Hi everyone, I have a smart form that takes input from a user. This data then goes into the sheet - where there are complex formulas within to make certain calculations - later used to create certain metrics etc. The nature of this sheet means that it will be continually added to, meaning at some point, it will be a good…
-
counting multiple select column
Hello, I have a project plan that I'm trying to report on. I have a column for health check and a column for assigned team. I want to see a total count of each status per team. That is the easy part and I figured that out by doing a =COUNTIFS({HealthCheck}, "Red", {Team}, OR(@cell = "FI", @cell = "FIT")) My issue is that…
-
Time to Complete a Task Less Time Wasn't In Lab's Possession
Hello all, I am struggling to get this formula correct for "Lab Time to Complete" column. Here's what I need to have done. I believe it's possible, but I keep getting errors and think I may be quite a ways off the mark. If "Destructive Testing Pending Days" and "Third Party Pending Days" are empty, find networkdays between…
-
Is it possible to only copy certain cells with automation?
We have a Master Task Order list which contains a multitude of data for a single project. At different stages of the process, parts of this data are copied to multiple other sheets. Is it possible to set up an automated workflow that would copy only specified parts of this data when criteria is met? I.e. select which…
-
IF formula to Assigned To
I am having trouble trying to figure out the formula based on the example: If the ISSUE TYPE is PTO, then assign it to XXXX. I have one column labeled "Issue Type" with a dropdown selection, and the other column labeled "Assigned To". Please help!
-
% Complete Average Column Formula
I am currently using a Column Formula to calculate % Complete. The formula is a combination of two checks: Children rows calculate based on a check box "Complete" column. The % complete will be calculated as 0% for an unchecked box or 100% for a checked box in the Complete column. Parent rows are designed to calculate the…