-
Removing Leading Zeroes Formula
I can't seem to find this anywhere, but how would you create a formula to remove leading zeroes in a helper column?
-
Sheet References from multiple sheets
Struggling with cross referencing multiple sheets. Sheet 1 - is auto-filled by a form from users in multiple areas. Sheet 2 - contains the standards for one area. Sheet 3 - needs to pull from sheet 1 (Task) and (Time) respective to area M1 & from sheet 2 The (Standard Time) relevant to Stanard Task I have been attempting…
-
Automation Not Responding to VLOOKUP
Hello Everyone, I have some data coming in from DataShuttle every morning to update status on pieces of work identified by 'OMNI #'s' (ex. OMNI123456). I have a formula in my sheet that looks at the OMNI number we put in then goes to the import from DataShuttle to find what the status was updated to that morning. Here is…
-
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…
