-
Count unique values based criteria
I want to count the unique values in my data, but based on a specific criteria. I have set up my data as above, and I want to get the unique count of Date and Handyman, but I would like to do it based on the value in the Month column. I know I can manually select the relevant rows for each month, but ideally if I can set…
-
Multiplication formula
Hello All, There is a question for multiplication formula. the one of cell is a formula, i need to use the price of this cell to multiply, but showed incorrect. Like below. Please help. Thanks in advanced. Zitong
-
Converstion of Date into Quarter & Year
Hello, I'd like to convert a date into a quarter as the following example illustrates: If the date is 07/10/2023, how do I get this converted into Q3 - 2023 in a new column I've created?
-
Status Formula
I need some help fine-tuning this formula. I need it to follow the following rules. Open to better options!!! It would need to be on a parent row. It will summarize the children's status. Rules: If all are 'Not Started' then the summary should show 'Not Started'. If all are 'Completed' then the summary should show…
-
Find Average Number if Criteria is Met
I need to determine the AVG number from a list of numbers if the Year and Week Number criteria are met. For example, if the Year is 2025 (Year Column) and the Week Number is 1 (Week Number Column), I need the average number of days in the FO Node Upgrades Duration column. I know that this formula =COUNTIFS({Year}, "2025",…
-
Extract date from the string (text)
Can anyone recommend a formula to extract date from the string of any length? Example: "Property: Maple, Ltd Balance Due 1/1/2022" or "12/1/2021 Balance due for Napa" . The string could be of any length and the date could be placed anywhere within the text. But it will always have two "/" characters. Unfortunately, date…
-
IF statement that can pull data from more than one cell if
We are using Smartsheet as a ticketing system for reporting guest issues. I have set up a form for our team to use where they can select the "primary issue category", and then based on the issue they choose, it gives them another drop down where they can choose a "secondary issue" where they can be more specific about what…
-
Update parent value if all children are a specific value, leave alone otherwise
I'd like to update the main parent row cell to "Complete" if all the children are also set to "Complete". Otherwise, I'd like the parent row cell to just be left alone (it will be blank until everything else is "Complete)". I can make this happen based on the other statuses the children show by using a bunch of COUNTIFS…
-
End of Month Function
Good afternoon all, I'm trying to figure out how to apply the =EOMONTH(A1,0) from excel into a smartsheet. Any guidance on this would be most appreciated! Thanks!
-
Formula cells are breaking because the cells are linking to one another inside the sheet
I built out a metric sheet and use sheet references within the cell formula. It was all linking and working correctly. I noticed last week that one of the formulas was not correctly calculating the total as it was previously. When I try to fix the formula and reference the correct column from the other sheet it breaks…