-
Error Returning Result Using COLLECT with MAX Date Criteria
I have 5 source tables where raw data is added to monthly (Titled Phase 0, Phase 1, etc). 4 rows of data are added each month to each source table, one for each Results Category option of Success, In Progress, Error, Unknown. One of my source tables is shown here Separately, I have a summary sheet, where I would like to…
-
Auto Number based on criteria
I have a sheet that we use to track all of our out of scope tasks that will be priced as Change Orders. All of our jobs are tracked in one sheet and are either FFP or WAF when entered. Once they are approved they move to another sheet so the formulas do not change the pricing. Is there a way to auto number based on Job…
-
COUNTIFS+CONTAINS+AND
I am trying to write a sheet summary formula to count the number of rows where: Sprint Name contains "Maintenance", Date Resolved is not blank, and Bug or Request equals "Bug" [Sprint Name]:[Sprint Name], CONTAINS("Maintenance") and [Date Resolved]:[Date Resolved], <>"" and [Bug or Request]:[Bug or Request], "Bug" I tried…
-
Weekly Data Report Showing Trends by Month
We export data weekly showing the number of registrations for a variety of products. I have the data in a line graph showing the trend over time but the graph doesn't display the value of the date. Ideally, I would like to simply display the value of each month on my dashboard while retaining the data that is updated…
-
Count the number of projects assigned per person via a multi-contact cell
Hi, I have a main sheet which tracks all the different projects going on. One of those columns labelled 'CM' tracks who has been assigned. It is restricted to contact values, sometimes there is 1 contact assigned, and sometimes there is 3. I want to be able to insert a graph on my dashboard which shows the number of…
-
COUNTIFS formula not working
I'm trying to write a formula for my metrics summary sheet that will count the number of assignments each designer has, if that project is currently in progress. I have a formula that works to gather the total # of assignments for each designer: =COUNTIFS({Tasks per users}, HAS(@cell, [Primary Column]@row)) But when I try…
-
How to highlight the Duplicate values in same cell?
Excel have Conditional formating option for hightlight the duplicate values. Is There any option for highlight the duplicate values in smartsheet?
-
Visitor Sign-In Sheet
Hello, I am trying to see if it is possible to create a visitor sign-in sheet with the time in and the time out in the same line. I already created a form with the logic where the visitor would manually enter in a time in. However, is there a way to enter in the time out on a separate form on the same line? I already tried…
-
Sweep to update fields in a criteria?
I am looking to set up a daily automation that checks if we have any fields that meet a specific criteria and update another field to fix out of sync data. My specific usecase is that, on a daily basis, I want to have an automation check to see if we have any project statuses in 'complete' or 'cancelled' and the phase is…
-
AverageIf with multiple criterion
I would like to find the Average Resolution time (Days) for rows where the date closed is in June 2023. =AVERAGEIF(AND([Date Closed]:[Date Closed], >DATE(2023, 6, 1), [Date Closed]:[Date Closed], <DATE(2023, 6, 30)), [Resolution Time (Days)]) I'm getting Invalid Data Type. Thank you in advance!! Jennifer