-
Setting up a sheet with names
How can I have a calculation sheet where all the names of the main project sheet will appear on, automatically? So for example, someone new has joined the project. They have a task now, on the main project sheet. I would like this person's name (so they are in the "assigned to" column) to show up on the calculation sheet…
-
SUMIFS or SUM(COLLECT) With Cross-sheet Reference
I'm trying to total up hours from a timesheet for each individual across multiple projects. I've tried the following two formulas but both are returning 0. SUMIFS({Timesheet Hours}, {Timesheet Name}, [Resource Name]@row, {Timesheet SOW}, SOW@row) =SUM(COLLECT({Timesheet Hours}, {Timesheet Name}, [Resource Name]@row,…
-
Auto Populate Dates and email to Form
Hi All, i have smart sheet form with dates, and i want to populate the date as per status dropdown. once the status changes the date should auto populate to the form date field. also, is there any way i can auto populate email id's in form field whenever new user is going to submit responce. i have set automation to send…
-
Pulling multiple information from one sheet to another
Hi everyone! I need to calculate some information based on several criteria. I have a sheet called Quality and in it, there is a lot of information. but the columns i need is; Date, Product type, Good quality and total quantity. In the product type collums we have 3 different products, but we only need 2 for this…
-
HELP! How do I modify my formula to separate months and years?
I am separating "Total Monthly Sales," but I need to separate the years as well. For example, our projects were sold in 2021, but carried over into 2022. I need to be able to separate 2022 and 2021. Here is my formula: =SUMIF([Date Awarded]:[Date Awarded], IFERROR(MONTH(@cell), 0) = 1, [Contract Amount]:[Contract Amount])
-
Looking to count the number of times a string of specific text occurs in a column
I want to use a count formula to determine the number of times a SKU occurs in an open text column. Below is the formula for the highlighted cell: =COUNTIF(SKU:SKU, CONTAINS("SKU2", @cell)) The value I am looking for is 3 because SKU2 appears 2 times in the 3rd row and once in the 2nd row. Any insights on how to count…
-
Count # of issues with the same Assigned Date
I have an issues tracker with Status drop down column and an Assigned Date column noting the date the issue was assigned to someone. I want to count the total issues by Assigned date that are in specific status, i.e.: Open, Client, Retest, etc. Looking for something that says Status = Design Change Date= 10/5/22 Count = 10
-
Tracking Days of the Week Using a Symbol Column
Hello, Trying to see if there is a way to incorporate the progress bar option in the symbol column to track days of the week. Ex: If today is Monday, the bar would be empty, but if it was Wednesday, the bar would show as half full and Friday the bar would be full. Is there a formula that can accomplish this?
-
Rollup Health
So ... on further thought. Is there a way to add to my existing rollup formula (see below): =IF(COUNTIFS(CHILDREN(), "Red") > 0, "Red", IF(COUNTIFS(CHILDREN(), "Yellow") > 0, "Yellow", IF(COUNTIFS(CHILDREN(), "Green") = COUNT(CHILDREN()), "Green"))) that adds: If 5 or more tasks are yellow turn “yellow” If 3 or more tasks…
-
Sumif Index Match multiple criteria
Hi, I would like to add the quantity in another sheet if they match 4 criteria in my sheet. For instance; I would like to add the quantity (from the Orders Sheet) of material ordered for each item in the Costing Sheet, to compare with what we costed on. Below is the Costing Sheet, so I would like to add up the quantities…